I have a relationship like following
Now i use the following query to get the all the city and country which have or does not have a relationship with country.
and it is giving me the country of the city which is directly related with country and also all the cities.
But I want to get a list like following
country | region | city
c1 | null | ct1
c2 | r1 | ct2
c3 | r2 | ct3
c4 | null | ct4
Is this possible, can someone help regarding this.