>>Or you can switch table 2 and 1 and use a left join. E.g. select
>>
>>nvl(myTable1.PK, myTable2.PK) as PK from myTable2 left join myTable1 ...
>>
>>You can also always use FULL OUTER JOIN.
>
>Thank you, again.
Actually, I didn't read your tables closely enough. In your particular case you MUST use FULL OUTER JOIN.
If it's not broken, fix it until it is.
My Blog