MySQL Forums
Forum List  »  PHP

help php mysql (beginner)
Posted by: lax bhat
Date: July 03, 2005 12:46AM

i have two tables in sql .
i want to execute query something like this!! example::
select * from table1 where id=(select id from table2 where country_name="america")
i think sub queries is not supported in the version of mysql i am using so can any body tell me another way to execute this query in simple manner. any help would be appriciated. thank u

Options: ReplyQuote

Written By
help php mysql (beginner)
July 03, 2005 12:46AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.