Which Of The Following Query Combines Data From More Than One #429

 USE SCRATCH GO SELECT TOP 1000 * FROM REMOTE.Scratch.dbo.Table1 T1 INNER JOIN REMOTE.Scratch.dbo.Table2 T2 ON T1.ID = T2.ID 

USE SCRATCH GO SELECT * FROM dbo.Table1 T1 INNER JOIN REMOTE.Scratch.dbo.Table2 T2 ON T1.ID = T2.ID WHERE T1.GUIDSTR < '001' 

 USE SCRATCH GO SELECT TOP 500 * FROM REMOTE.Scratch.dbo.Table1 T1 OUTER JOIN REMOTE.Scratch.dbo.Table2 T2 ON T1.ID = T2.ID