s.PLAYERID
order by TPM desc
limit 10;
(this may or may not work/parse properly, as i didn't actually try it, YMMV,
etc.etc.etc.)
-ravi.
-Original Message-
From: Chad Day [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 23, 2001 10:59 AM
To: [EMAIL PROTECTED]
Subject: Help with a semi
I have 4 tables, named:
players - stores player id, name, team id
teams - teamid, teamname
goals - goals scored, player id, team id
penalty - penaltys accumulated, player id
What I'm trying to do is write a query to get the top 10 from any category
and display them. I can do them individually f
