Re: Inner selects

>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,dept

Inner selects

e 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. B