Re: Subqueries too slow

[Jay Pipes]

Oh! OK!

SELECT a.id, a.acc, a.name
FROM a
INNER JOIN b
ON a.id = b.a_id
INNER JOIN c
ON b.c_id=c.id
AND c.acc IN ("X" ,"Z")
LEFT JOIN (
SELECT b.a_id
FROM b
INNER JOIN c
ON b.c_id=c.id
WHERE c.acc="Y"
GROUP BY b.a_id
) as dt
ON a.id = dt.a_id
WHERE dt.a_id IS NULL;

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com