Can anyone tell me how can I write the equivalent of a left join without really using left joins.
Select * from a left join b on a.name = b.name.