Pardon me, It should have read Player not Name in table 1. I don't get an error I get ID | Name | Player | goals | assists | shutouts | points ------------------------------------------------------------------------------ 1 rob J.Doe 2 3 5 1 K.Red 1 4 5 1 B.Blue 0 0 1 3 2 Keith L.Dog 1 1 2 2 C.Cat 1 1 2
Here is the problem: This query has only given the 1st instance of a player and his stats. ID 2 ,Keith ALSO HAS B.BLUE LISTED on one row of draftees. Why is that information not being printed out ? I apologize if my original post was to vague... 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
