socalnate Posted June 29, 2007 Share Posted June 29, 2007 Here's the statement: SELECT gamesnew.game_name, sort_date, thumb, flash_file, genres.genre, descriptions.description, ratings.num_votes, score FROM gamesnew LEFT JOIN genres ON gamesnew.game_name = genres.game_name JOIN descriptions ON genres.game_name = descriptions.game_name JOIN ratings ON descriptions.game_name = ratings.game_name Each table has one column [game_name] that is unique per table (ie the game names aren't duplicated). I set the KEY as the ID (which varies per table so it's useless for my purposes) but my game_name in each table I set to UNIQUE so that for each table the unique identifier is the game name and nothing else. The SQL statement works but the problem is is that it doesn't select ALL the [game_name]'s from the table gamesnew even if the info isn't complete for the other tables. It should (in theory) select all 18,000 game_name and display them with the joined content from the other tables and just leave blanks in the incomplete info right? I don't know why it's only selecting about 1,500 games (but oddly all the info is complete with the data it does select). ??? Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.