vikas kanani

vikas kanani

  • 1.5k
  • 149
  • 111.9k

join

Feb 23 2013 5:46 AM
my question is

suppose i have 5 tables.that are countrymaster,statemaster,citymaster,wardmaster,zonemaster

1.countrymaster-->pk.countryid,countryname
2.statemaster-->pk.stateid,f.k.countryid,statename
3.citymaster-->pk.cityid,f.k.stateid,cityname
4.wardmaster-->pk.wardid,fk.cityid,wardname
5.zonemaster-->pk.zoneid,fk.wardid,zonename

that type of structure in tables..

now i hav to create a view of those table.

i mean my view structure is    countryname,statename,cityname,wardname,zonename..


so how can i do using join.



Answers (3)