>>COALESCE(R.KEY_VAL,REPORT_REQUEST.KEY_VAL)=MASTER.KEY_VAL
>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.

Excepting 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.

Set