4 tables Query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

4 tables Query

Author

Topic

kooka
Starting Member

4 Posts

Posted - 2009-11-21 : 19:14:42

Hi,
I'm not good in T-SQL. Can anybody tell how to optimize this query,
SELECT * FROM Table1 WHERE ID1 IN
(SELECT ID1 FROM Table2 WHERE ID2 IN
(SELECT ID2 FROM Table3 WHERE ID3 IN
(SELECT ID3 FROM Table4 WHERE ID4 = 'someData')
)
)

Best Reagards,
kooka

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-11-21 : 22:02:03

[code]
SELECT t1.*
FROM Table1 t1
JOIN Table2 t2
On t1.ID = t2.ID2
JOIN Table3 t3
On t2.ID2 = t3.ID3
JOIN table4 t4
On t3.ID3 = t4.ID4
WHERE t4.ID4 = 'someData'[/code]

kooka
Starting Member

4 Posts

Posted - 2009-11-23 : 09:09:17

Thank you Sir!

kooka
Starting Member

4 Posts

Posted - 2009-11-23 : 19:24:00

SELECT *
FROM Table1 T1
JOIN Table2 T2
On T1.IDT1 = T2.IDT2
JOIN Table3 T3
On T2.IDT2 = T3.IDT3

Let’s say,
T1 has IDT1, IDT2, min, max
T2 has IDT2, IDT3
T3 has IDT3, kind

T3 has values like
1 , A
2, B

I want to get the data like
IDT1 , min (tied with A value of “kind” column) , max( tied with A value of “kind” column) , min (tied with B value of “kind” column) , max( tied with B value of “kind” column) ,

Please, tell me what will be the query?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources