needs alternativesto not exists

[glider]

hello pals


Hi, I have to rewrite my MySQL query since the current version of MySQL installed is not supporting NOT EXISTS. Upgrading to newer version is not applicable at the moment since it is not allowed.

So, here's my query:


Code:
SELECT *
FROM p, r
WHERE p.prospectid = r.prospectid
AND NOT
EXISTS (

SELECT *
FROM ck
WHERE ck.referralid = r.referralid
)
AND NOT
EXISTS (

SELECT *
FROM nck
WHERE nck.referralid = r.referralid
)

FYI, I am using MySQL 4.0.21-nt.

Thanks -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[christopher]

Try this code

select p.foo
, r.bar
from p
inner
join r
on r.prospectid = p.prospectid
left outer
join ck
on ck.referralid = r.referralid
left outer
join nck
on nck.referralid = r.referralid
where ck.referralid is null
and nck.referralid is null -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --