Hi all, I have a table like this:
id data year 1 2 01 2 2 01 6 2 01 7 2 01 8 2 01 11 2 01 What i want to be able to get is these results from an sql query (given that i want id's 1-9): id data year 1 2 01 2 2 01 3 0 0 4 0 0 5 0 0 6 2 01 7 2 01 8 2 01 9 0 0 Basically it has made up the rows with id's 3,4, 5 and 9 because they didnt exist in the table. Can anybody give me any clues how to achieve this? Thanks, Jamie Burns. --------------------------------------------------------------------- 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