OK, turns out this was a two fold issue.
The server I was on had 4.0 mySQL, which was severely limited in it's
abilities to use subqueries. The server has since been update to the 4.1
series, and now the following 2-subquery query work just fine.
SELECT firstname, lastname, B.playerid,
How do I simply find out who the bubble is now in my db now that we track more than 1 $0 person. I need just the person
with $0 in the amount column with the lowest Place for each date.
I can iterate through it all if needed in PHP, but I am always looking to learn
more SQL tricks.
I am