Select statement

Anon

Hello, I'm new in mySQL. I need to create SQL Select query. In Oracle database it will looks like:
select * from table1 where id =
(select max(id) from table2);
Do you have some suggestions, how to do this using mySQL?
Thanks

Anon

It should be exactly the same as Oracle:

mysql_connect("localhost");
mysql_select_db("my_database");
$query = "select * from table1 where id =
(select max(id) from table2)";
$result=mysql_query($query);

You'll need to feed the result set to one of the mysql fetch functions to get the individual fields. I have assumed that both tables are in the same database.

Good luck!

Anon

Hmmm how about reading a manual once in a while....

www.mysql.com

Anon

mySQL does not support sub selects.

http://www.mysql.com/documentation/mysql/commented/manual.php?section=Missing_Sub-selects