You should use LEFT JOIN. Regards,
> I am perplexed trying to retrieve all the rows I need in the query > I'm doing. > > I have a table with keeping track of people using ID numbers as the primary > key and another table with coupon numbers and a reference to the > first table. But not all the second table is going to have > correlating matches to the first table. So, in other words not all > people have a coupon number entered into the database. > > I run the query: > > SELECT table1.id, table2.coupon FROM table1, table2 WHERE > table1.id=table2.person_id; > > I expect back a report of the 213 rows in table1 and their matching > coupon # if they have one. Instead, I get 174 rows and THEIR > matching coupons but no results from the others. I want to write a > query that will return the id's from table1 and the table2 coupon > regardless of whether the table2.person_id matches table1.id. > > How do I do this? > > Thanks, > Dean > > --------------------------------------------------------------------- > 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 <mysql-unsubscribe- [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu C&A Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.com --------------------------------------------------------------------- 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