Hello, I am having a difficult time figuring out how to get a certain specific result from the database .
>>Example tables: table1 ID|name ------- 1 |15 2 |25 3 |50 table2 ID|code ------- 1 |1 2 |2 3 |2 >>My query select * from table1,table2 WHERE table1.ID = table2.code The current query returns all records in table2 that match the ID in table1 but what I want it to do is return only one record from table2 for each match in table1 >> Query results 1 2 2 >> Desired results 1 2 Thanks for any help. Jeff --------------------------------------------------------------------- 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