Re: empty string or null

Andreas Mosmann schreef:
[snip]
> try a JOIN ...
> SELECT * FROM ADDRESSES A
> LEFT JOIN JOBS J ON
> (A.FIRSTNAME=B.FIRSTNAME) and (A.MIDDLENAME=B.MIDDLENAME) and
> (A.FAMILYNAME=B.FAMILIYNAME);
>
> no MIDDLENAME- no job
>
> Andreas Mosmann
>
>

Does this mean I have a job, and you don't? :)

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...