Nested query In MYSQL

[Haai]

how can write a mysql query for nested query.
ex:
select Student.NAME from Student where Student.NAME = (select Citizen.NAME from Citizen where Citizen.NAME="boy"

o/p string for this query is:
ERROR 1064: You have an error in your SQL syntax near 'select Citizen.NAME from Citizen where Citizen.NAME="boy' at line 1

 

[doddo]

hi, nested selects aren't supported yet.

you could create a temporary table with the inner select, or the following should work:

select Student.NAME from Student,Citizen where Student.NAME =Citizen.NAME and Citizen.NAME="boy"