Left Outer Joins

Select * From A Left Outer Join B On A.Id= B.Id