|Subject||Re: [IBO] FULL JOIN|
|Author||Svein Erling Tysvær|
>>COALESCE(R.KEY_VAL,REPORT_REQUEST.KEY_VAL)=MASTER.KEY_VALExcepting those cases where both R.KEY_VAL and REPORT_REQUEST.KEY_VAL IS NULL, that will be no problem, Luiz, COALESCE returns the first column that IS NOT NULL. And I think both were defined as NOT NULL in his table definition. I doubt COALESCE is the answer to every thinkable situation with FULL JOIN, but that it sufficed this time where the FULL JOIN was on R.KEY_VAL = REPORT_REQUEST.KEY_VAL and both fields were defined as NOT NULL.
>I think this will solve the problem when R.KEY_VAL is null, but what about when REPORT_REQUEST.KEY_VAL is null? If I remember it´s a FULL JOIN.