--第一种写法
SELECT * FROM (SELECT * FROM Table1 WHERE Name LIKE 'One%') a LEFT JOIN Table2 b ON a.ID=b.ID
--第二种写法(跟第一种效率是一样的)
SELECT * FROM Table1 a LEFT JOIN Table2 b ON a.ID=b.ID WHERE a.Name LIKE 'One%'
--第三种写法(如果 Table1,Table2 都是大表，而且第1个select条件过滤后记录很少，效果显著 )
SELECT * INTO #tmp FROM Table1 WHERE Name LIKE 'One%'
SELECT * FROM #tmp a LEFT JOIN Table2 b ON a.ID=b.ID
