is not NULL) or (colors.parent_id
is not NULL))
I need to do some more testing to be sure.
Rich
-Original Message-
From: Edward Peloke [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 08:46
To: Richard Bolen
Subject: RE: Complex SQL query problem...
After I sent this it hit me
great! hope it works !
-Original Message-
From: Richard Bolen [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 9:17 AM
To: MySQL Mailing List (E-mail)
Cc: Edward Peloke
Subject: RE: Complex SQL query problem...
FYI - this query seemed to work.
select * from nodes
left join
try a left join
select count(*) from jobs
left join submissions on
jobs.standard_id=submissions.color_id
where jobs.standard_id=ID_VALUE and submissions.color_id is null
Eddie
-Original Message-
From: Richard Bolen [mailto:[EMAIL PROTECTED]]
Sent: Friday,
(E-mail)
Subject: RE: Complex SQL query problem...
try a left join
select count(*) from jobs
left join submissions on
jobs.standard_id=submissions.color_id
where jobs.standard_id=ID_VALUE and submissions.color_id is null
Eddie
-Original Message-
From: Richard