MySQL Forums
Forum List  »  Newbie

Trouble making formula.
Posted by: Gordon White
Date: May 02, 2016 07:26AM

I need to pick a value from a table with the following conditions. Everything I try either returns '0' or blows up.

Pick from "data" where column "points" is between 1 and 7 and only associated with the "max(dateid)" column with a limit of the top 7 players.

Also I need to pick "b.name" from "players b" where a.playersid = b.playersid.

I will only output the top 7 places.

Please can someone help me out. My problem is I can't figure out how to associate my "name", "points" with "max(dateid)" dynamically.

I have been working on this for 4 days and am getting extremely frustrated.

Thanks

Options: ReplyQuote


Subject
Written By
Posted
Trouble making formula.
May 02, 2016 07:26AM


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.