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]
