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

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

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

Answers

Getting data from these 5 tables query

Kansolve Developer8

616

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

Answers (2)

Next Recommended Forum

How to recover corrupted data

SSIS Jobs runs slowly in SQL 2008 server