What you have there is a subselect, which are not supported in mysql 3.2x,
but I *believe* are supported in 4.0+ (gamma and 4.1alpha). Don't take my
word for it and check the docs first.
--Joe
--
Joe Stump [EMAIL PROTECTED]
http://www.joestump.net
Label makers are proof God wants Sys Admins to
thanx joe, i checked.
I just thought that there could be a way around this problem!
From: Joe Stump [EMAIL PROTECTED]
To: Inandjo Taurel [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: How to write delete query??
Date: Mon, 17 Feb 2003 09:46:53 -0800
MIME-Version: 1.0
Received: from
Inandjo,
- delete from table1 where table1.field1 in (select distinct field2 from
table2).
Subselects (or nested queries) like that are supported as of MySQL
4.1. At this moment, you will have to compile 4.1 yourself; it's
expected to be out as a binary version in the next couple of weeks.
The
Inandjo
- delete from table1 where table1.field1 in (select distinct field2 from
table2)
From what I've read subqueries are not yet supported. We worked around
this by converting the distinct list to a comma delimited list of
values. E.g.,