>>

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

>
>Exactly what I would have done. The only slight modification I'd suggest is to use nvl() instead of the iif(isnull()), it works the same but is more lightweight than the combination of two functions. Depending on the number of records pulled at a time this may or may not mean a difference in speed.

You're absolutely right Dragan :)
Cetin