Re: empty string or null
- From: Frank van Bortel <frank.van.bortel@xxxxxxxxx>
- Date: Thu, 29 Mar 2007 19:52:49 +0200
Andreas Mosmann schreef:
[snip]
try a JOIN ...Does this mean I have a job, and you don't?
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
:)
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
.
- Follow-Ups:
- Re: empty string or null
- From: Andreas Mosmann
- Re: empty string or null
- References:
- empty string or null
- From: Tim B
- Re: empty string or null
- From: Frank van Bortel
- Re: empty string or null
- From: Andreas Mosmann
- empty string or null
- Prev by Date: Re: Pass-through Query Doesn't Return Expected Results
- Next by Date: Re: Getting last sequence number in c#
- Previous by thread: Re: empty string or null
- Next by thread: Re: empty string or null
- Index(es):
Relevant Pages
|
