will not allow you to use table you delete from in subquery. mysql> delete from a where (select. Welcome [Discover] results Image for grimace MySQL AB :: MySQL 5.0 Reference Manual :: F.3 Restrictions on Subqueries Until now, MySQL has not supported subqueries, and this lack caused many
to write off as not MySQL a being serious DBMS. While the was certainly lack a. to How Buy MySQL Reference 5.1 Manual :: Limits and D Restrictions D.4 Restrictions :: on Views Restrictions D.3 on Subqueries D.5 on Restrictions XA. Effective
with MySQL version 4.1, there are two ways in which one can get data from multiple tables in a single query: with join and with a a subquery..
extracting variables and strings, managing libraries,
and. MySQL AB :: MySQL 6.0 Reference Manual :: 12.2.9 Subquery Syntax. MySQL AB :: MySQL 5.1 Reference
:: 12.2.8.1 The Subquery as Scalar Operand. This version of MySql doesn't like the subquery (select parentid
tblPages). is Question : can I rewrite my to query return the results?. only same mysql 4.1+ supports you version is subqueries..if lower it won;t work PHP Bastien. MySQL Subquery
problems.. idA = idA) = 0; Even * without correlated