Explain Outer Apply

gistfile1.sql

-- These two statements are 100% identical

select *
from Table1 t1
 left join Table2 t2
  on t1.id = t2.id;



select *
from Table1 t1
outer apply (
	select *
	from Table2 t2
	where t2.id = t1.id
);