select a.field1, a.field2, ; >> b.field3, b.field4 ; >> from tableA A ; >> left join tableB B ; >> on a.field1 = b.field1 and ; >> a.field2 = b.field2 >> >>*or NULLS replaced with 0 >> >>select a.field1, a.field2, ; >> <b>nvl(b.field3,0)</b> as 'field3', ; >> <b>nvl(b.field4,0)</b> as 'field4' ; >> from tableA A ; >> left join tableB B ; >> on a.field1 = b.field1 and ; >> a.field2 = b.field2>