MySQL Forums
Forum List  »  InnoDB

Re: Problem with selection of multiple tables
Posted by: Vinod Sugur
Date: January 13, 2009 07:03AM

Hi,

Please check the below query:

============================================================

select p.username,gs.status,sum(sif.item_points)
from players p, game_status gs , special_items_found sif
where p.player_id = gs.player_id AND
gs.player_id = sif.player_id AND
(p.player_id,gs.status_date) IN
(Select player_id,max(status_date)
from game_status
Group by player_id)
Group by p.username,gs.status
;

============================================================

Let me know if this helps.

Regards,
Vinod

Options: ReplyQuote


Subject
Views
Written By
Posted
2841
January 10, 2009 05:52PM
Re: Problem with selection of multiple tables
2072
January 13, 2009 07:03AM


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.