Bug #650 Nested selects in a query
Submitted: 13 Jun 2003 6:56 Modified: 13 Jun 2003 7:06
Reporter: Goutham S Mohan Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:MySQL 3.23.56 / MySQL 4.0.12 OS:HP/UX (HP-UX)
Assigned to: CPU Architecture:Any

[13 Jun 2003 6:56] Goutham S Mohan 
Description:
Are nested selects (sub selects) supported in MySQL.
Select statement:
select id, name from Table_name1 where id in (select id from Table_name2);

Note: Assume that Tables are appropriately defined.

We are using MySQL 3.23.56-MAX and may move to MySQL 4.0.12 provided some of the other defects are resolved. So, can we know whether MySQL supports such queries in either of these versions. If not will it be in supported in the coming ones.

How to repeat:
Refer to Description
[13 Jun 2003 7:02] Goutham S Mohan 
Reference - Kerry Ancheta
[13 Jun 2003 7:06] MySQL Verification Team 
These are available in 4.1