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
rnoid = ''
HTH
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
- Original Message -
From: "David Phipps" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, February 03, 2003 15:46
Subject: Problem with a query -
ECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, February 03, 2003 15:46
Subject: Problem with a query - help!!?
> Hi,
>
> I am new to this list so I apologise if this is not the place to post this
> message.
>
> I am in the final stages of completi
uot; <[EMAIL PROTECTED]>
Sent: Monday, February 03, 2003 8:46 AM
Subject: Problem with a query - help!!?
> Hi,
>
> I am new to this list so I apologise if this is not the place to post this
> message.
>
> I am in the final stages of completing a project and I have one query
Hi,
I am new to this list so I apologise if this is not the place to post this
message.
I am in the final stages of completing a project and I have one query that
is causing problems.
I need the query to get a story or stories from the story table and
journalists from the journalist table whe