illegal query

[joost]

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

[David E. Smith]

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