inner join - 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

SQL Server 2005 Forums

Transact-SQL (2005)

inner join

Author

Topic

rum23
Yak Posting Veteran

77 Posts

Posted - 2009-05-12 : 23:45:20

SELECT * FROM TableA
WHERE Field1 IN (
SELECT Field1 FROM TableB WHERE Field2 IN (
SELECT Field2 FROM TableC WHERE
Field4=4 AND ProjectID='9989A38'))

how do we convert the above SQL to use inner join? Please help

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-05-12 : 23:47:59

[code]SELECT *
FROM TableA a
INNER JOIN TableB b ON a.Field1 = b.Field1
INNER JOIN TableC c on b.Field2 = c.Field2
WHERE c.Field4 = 4
AND c.ProejctID = '9989A38'[/code]

KH
[spoiler]Time is always against us[/spoiler]

rum23
Yak Posting Veteran

77 Posts

Posted - 2009-05-12 : 23:53:44

Perfect! thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources