--- In firebird-support@yahoogroups.com, Raymond Kennington
<progsol@c...> wrote:

> Raymond Kennington wrote:
> Replace my last suggestion with:
>
> SELECT A.Employer_ID, A.Employer_ID, B.Salary, B.Salary
> FROM A FULL OUTER JOIN B
> ON A.Employer_ID = B.Employer_ID
> WHERE NOT ( (A.Employer_ID = B.Employer_ID)
> AND (A.Salary = B.Salary))
>
> Conditions for NULLs could be included, but I think they are
> irrelevant.
> --

Thanks, but hope you know that
(A.Salary = B.Salary)
will always fail when both are null :)
We need a stronger comparison operator, since null is used really
often with ambiguous meaning (something like '==').
regards
Marco Menardi