help with select query

[Anon]

Hi All,

WOndering if someone can please give me a hand here.

Im trying to do a query in mysql where i am shown all the records that have the same email as the first record in the table. The trick is that the first record int he table does not always have id=1 because records are added to and deleted out of the table on a regular basis.

I was thinking of something along the lines:

select * from table where email=(select email from table where id=(select min(id) from table));

but cant seem to get it to glue properly.

Any help would be greatly appreciated.

Many Thanks

Dave

[Anon]

THought i should add on that i am using mysql version: 3.23.37-Max

the error i get when i try and run the command from the server is:

select * from temp where email=(select email from temp where id=(select min(id) from temp));

ERROR 1064: You have an error in your SQL syntax near 'select email from temp where id=(select min(id) from temp))' at line 1

Thanks

Dave

[Anon]

mySQL doesn't do sub selects.

[Anon]

Is there any other way i can do this?

Dave

[gcohen]

Could you try doing the sub SQL statement and put the value into a variable, then use that variable into the second SQL statement?

[Anon]

I have tried that but to no avail.