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 ?