Can I work with a subquery in MySQL?
Example SELECT COD, DATA FROM TAB where COD =(select DISTINCT COD FROM MOV)
In SQL it's possible, but is it in MySQL?
No.
No, but it is forecasted for release 3.24
finally!
FYI:
MySQL 4.0 lays the foundation for the new features of MySQL 4.1, such as nested subqueries, stored procedures, and foreign key integrity rules, which form the top of the wish list for many of our customers.
Also note that that which list has existed like that from version 0.1 of MySQL and so far they have realized exactly two of the items: row-level-locking and union.
