|
maevr
Posting Yak Master
Sweden
168 Posts |
 Posted - 10/16/2012 : 10:02:47
|
I need to write a query that selects records from multiple tables including a subquery but I belive I do something wrong since the select takes "forever" to run and the tempdb fills up quickly.
Smaller example:
select
a.id
,a.col2
,fa.col3
,fa.col4
,e.col5
,e.col6
,f.col7
from tbl1 a inner join
(select a1.id, b1.col2, c1.col3 from subTbl1 a1 inner join subTbl2 b1 on a1.id = b1.id inner join subTbl3 c1 on b1.id = c1.id
where a1.val = 'Yes') as fa
on a.id = fa.id inner join tbl2 e on a.id = e.id
inner join tbl3 f on a.id = f.id |
|
Multiple joins
