Results 1 to 2 of 2
Thread: question about select statement
Jan 12, 2005, 22:25 #1
- Join Date
- Apr 2003
- Hong Kong
- 0 Post(s)
- 0 Thread(s)
question about select statement
I have two MySQL table like this:
Can I combine
select name from game_table order by id desc
select count(id) from update_table where id = game_table.id and up_time > 50
to get sth like...
select game_table.name, update_table.count(id) from game_table, update_table where update_table.game_id=game_table.id and update_table.up_time > 50 order by game_table.id desc
<= this is just my thought.... i believe there is no such query ..
I would like to ask how can I write the query in order to meet my requirement ?