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  SQL Server Administration (2005)  Execution steps for Mixed Joins with Where clause

Author  Topic  learntsql 524 Posts Posted - 2009-12-18 : 05:10:37 Hi.. Could any body please tell me the execution steps of the select statement which is the combination of joins(LEFT/RIGHT and INNER) and WHERE clause. for eg: select T1.[Col1].... from <Table1> T1 LEFT JOIN <Table2> T2 ON T1.<Col1>=T2.<Col1> INNER JOIN <Table3> T3 ON T2.<Col1>=T3.<Col1> WHERE T1.<Clo1>='SomeValueHere' AND T3.<Col3>='SomeValueHere' TIA.