Re: Query driving me mad

[Jay Pipes]

You're using a MySQL version prior to 4.1, which is the first to support subqueries. Just change to use a join (which will be more efficient most times anyway):

SELECT e.*
FROM bl_ecomms_email e
INNER JOIN bl_ecomms_list_members m
ON e.email_id = m.email_id
WHERE e.email_dateOptOut = '0000-00-00 00:00:00'
AND m.list_id=2;

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

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