Hi,
I think the problem is that your assuming that journoNatOpt.journoid is
'' (empty) when journoDetails.journoid has no entry in journoNatOpt.
But that's not true, the value is NULL.
So, try replacing
AND journoNatOpt.journoid = ''
with
AND journoNatOpt.journoid IS NULL
On Mon, 2003-02-0
That was where I was going wrong. I had previously tried = Null which
doesn't work but IS NULL works.
Thanks.
Dave
At 11:46 2/4/2003 +0200, you wrote:
HI,
To test for records that are not present in a table you should use
journoNatOpt.journoid is NULL
instead of
journoNatOpt.journoid = ''
HI,
To test for records that are not present in a table you should use
journoNatOpt.journoid is NULL
instead of
journoNatOpt.journoid = ''
HTH
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
- Original Message -
From: "David Phipps" <[EMAIL PROTECTED]>
To: "MySQL List" <[
Are you sure u have
journoNatOpt.journoid = ''
records?
select count(*) where journoNatOpt.journoid = ''
If not, maybe IS NULL instead of = ''
will help.
- Original Message -
From: "David Phipps" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, February 03, 2003
N2
Best regards,
Mikhail.
- Original Message -
From: "Arul" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Saturday, June 29, 2002 07:32
Subject: Re: Pro
<[EMAIL PROTECTED]>
Sent: Saturday, June 29, 2002 10:32 AM
Subject: Re: Problem with a query
> No Mikhail
>
> I dont think i can agree with you .
> If you could see my first query which returned 3 rows also had a Having
> Clause.
> I just added an OR condition inside the qu
