from a left join b on a.id=b.id

or

from a,b where a.id=b.id