Re: Select in select statement

No support in 4.0 for sub selects, which can be a pain, normally you can 
get around it using joins .Try rewriting it as

SELECT r.reportid FROM reportfiles r inner join users u on u.username = 
r.username

or 

SELECT r.reportid FROM reportfiles r, users u
where u.username = r.username

cheers

mike

John Doolan wrote:

> Chris,
>         This feature is only supported in version 4.1 (which is
> currently a beta release).
>
> Regards,
>
>
> John Doolan
>
>
> -----Original Message-----
> From: Chris Tate-Davies [mailto:chris.tatedavies@xxxxxxxxxx] 
> Sent: 26 August 2004 07:44
> To: MyODBC List
> Subject: Select in select statement
>
> I am running MySQL version 4.0.18.NT and I am having a problem.
>
> The following statement works fine:
>
> SELECT reportid FROM reportfiles WHERE username IN
> ('chris','terry','dave');
>
> And the following statement works:
>
> SELECT username FROM users;
>
> But this does not work:
>
> SELECT reportid FROM reportfiles WHERE username IN (SELECT username FROM
> users);
>
> Is this a bug or unsupported feature? Surely not the case...
>
> Thanks, Chris
>
>      Chris Tate-Davies Tel: 01608 647 651
>      Technical Manager Email: chris.tatedavies@xxxxxxxxxx
>      CETA Limited Web: www.ceta.co.uk
>
>  

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx