as follows:
ERROR 1064: You have an error in your SQL syntax near 'select deptno
from emp where ename='scott')' at line 1
Does MySQL support inner select this way or is there another way to
achieve the same?
Thanks for your help.
Best Regards,
Michael Beaucourt
Michael Beaucourt wrote:
Hi all,
I was wondering if it is possible to perform an inner select in MySQL.
I have a database called EMP and when i enter the following query, I
keep getting error 1064:
select ename,deptno from emp where deptno in (select deptno from emp
where ename