Getting data from these 5 tables query

Mar 20 2018 5:52 AM
table1 
 Id ServicedId DepotId Sno Dname
     
     
 table2
 DepotId Dname DivisionId AddressStatus 
     
table3
 DivisionId DivisionName RegionId Date Status
     
table4
 RegionId RegName ZoneId Status 
     
table5
 ZoneId ZoneName Status Date 
     
How Can i get Data from these tables ZoneName, Count(Servicedid) give me a sql server query for it

Answers (2)