Nested selects in mySQL with PHP?

[QuietFire]

I can find a longer way around my problem, but when I was doing a lot of asp/MS SQL stuff I sued to do write some pretty specific queries. I tried this through phpMyAdmin and received syntax errors. I guess what I want to know more than anything is, is it possible in php/mysql?

SELECT userpermissions.location_id ,locations.loc_name FROM locations WHERE userpermissions.location_id IN (SELECT userpermissions.userid FROM userpermissions WHERE userpermissions.userid = '4')

like I said, I can get there in a round about way, but it seams something like this should be possible.

Thanks in advance,

Charlie

 

[Vragabond]

While your question is much better suited for the MySQL forum, since it has nothing to do with php, I will point you to your answer anyway. Subqueries have only become available in MySQL recently. If you have an older version, you need to upgrade. More:

http://dev.mysql.com/doc/mysql/en/subqueries.html

 

[ORettinger]

SELECT userpermissions.location_id ,locations.loc_name FROM  locations WHERE userpermissions.location_id IN (SELECT userpermissions.userid FROM userpermissions WHERE userpermissions.userid = '4')

Don't you miss anything in your "FROM"-Part?

SELECT userpermissions.location_id ,locations.loc_name FROM  locations, [red]userpermissions[/red] WHERE userpermissions.location_id IN (SELECT userpermissions.userid FROM userpermissions WHERE userpermissions.userid = '4')

I thought you must specify all your tables, but I'm not an SQL-guru

 

[QuietFire]

ORettinger.. I'm a little rusty...