All pastes #900129 Raw Edit

Unnamed

public text v1 · immutable
·published 2008-02-11 18:15 UTC
rendered paste body
select * from tA
   left join tB on tA.id = tB.id and tA.flag = 1
   where tB.code = 2

select * from tA
   left join tB on tA.id = tB.id 
   where tB.code = 2 and tA.flag = 1