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 = 'SCOTT')
The error message reads 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
--
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php