Getting data from these 5 tables query

Question

table1   Id  ServicedId  DepotId  Sno  Dname                      table2  DepotId  Dname  DivisionId  Address Status            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

Amit Gupta · Answer

Hey   You can solve this by yourself by using Sql query designer   Look at the link that helps you to understand https://www.mssqltips.com/sqlservertip/1086/sql-server-management-studio-query-designer/    Good Luck

Shahriar Nikkhah · Answer

It depends on your data,  anyways with clean and good data  the answer is   SELECT ZoneName , Count(Servicedid) FROM table5 T5 INNER JOIN table4 T4 ON T5.ZoneID         = T4.ZoneID INNER JOIN table3 T3 ON T4.RegionId      = T3.RegionId INNER JOIN table2 T2 ON T3.DivisionId    = T2.DivisionId INNER JOIN table1 T1 ON T2.DepotId        = T1.DepotId GROUP BY ZoneName