Hi, query question: I have 2 tables created using Mysql: 1) Players Name(varchar),Team(varchar),Goals(tinyint),Assists(tinyint),Shutouts(tinyint),points(int).
2)draftees ID(smallint),Name(varchar),Phone(varchar),Player(varchar) The problem I run into is when I run this statement only the first ID that has a certain Player is listed, even though multiple ID's may have the same player. SELECT ID,Name,draftees.Player,goals,assists,shutouts,points FROM Players INNER JOIN draftees USING (Player) WHERE Players.Player=draftees.Player ORDER BY ID I hope that I have explained my problem clearly, Any help would be appreciated... Rob --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
