ItzikJoin.sql

-- Itzik Join
SELECT  t1.Col1,
        t2.Col1,
        t3.Col1
FROM    dbo.table1 AS t1
LEFT JOIN	(
	dbo.table2 AS t2
	INNER JOIN dbo.table3 AS t3 ON t3.Col1 = t2.Col1
) ON t2.Col1 = t1.Col1;