Posting Yak Master
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.
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