Get equivalents via SQL?

[motorpsychkill]

I have a table like this (table_gender):

gender_id gender_descript ion
--------------- ----------------------------
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/mysql?unsub=m...ie.nctu.edu.tw