By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,417 Members | 1,833 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,417 IT Pros & Developers. It's quick & easy.

illegal query

P: n/a
Hello,

I'm kind of new to mySQL but more used to Sybase/PHP
What is illegal about this query or can i not use combined query's in mySQL?

DELETE FROM manufacturers
WHERE manufacturers_id NOT IN ( SELECT manufacturers_id
FROM
products )

Kind Regards
Joost Wolthuis

Jul 16 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
In comp.lang.php joost wrote:
I'm kind of new to mySQL but more used to Sybase/PHP
What is illegal about this query or can i not use combined query's in mySQL?

DELETE FROM manufacturers
WHERE manufacturers_id NOT IN ( SELECT manufacturers_id
FROM
products )


Many versions of MySQL don't support subselects. I think some of the
newest bleeding-edge versions do, but 3.x (which is probably what you're
running, as 4.0 is still fairly young) doesn't, period, IIRC.

....dave
Jul 16 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.