You need a LEFT JOIN. Check the manual for more info and let us know if you have any more questions.
Edward Dudlik Becoming Digital www.becomingdigital.com Did I help you? Want to show your thanks? www.amazon.com/o/registry/EGDXEBBWTYUU ----- Original Message ----- From: "motorpsychkill" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, 08 July, 2003 22:35 Subject: Get equivalents via SQL? I have a table like this (table_gender): gender_id gender_description --------------- ---------------------------- 0 female 1 male I also have a table like this (table_post): post_id post_gender1 post_gender2 ----------- ----------- ------------ 21 0 1 22 0 0 23 1 0 Is there any way that I can pull a singe row from table_post (for e.g. row 21) and have the results look like: post_id gender1 gender2 ----------- ------------ ------------ 21 female male Thank you very much! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
