SQL Query Help

[army20]

Hello everyone !

I'm using MySQL 5.0.15 on a local windows xp machine.

Here are my talbes

info_tbl:
-----------------------------
NM_PK	RANK	 NAME
123	 1	 Him 
234	 2	 Her 
456	 3	 Us 
-----------------------------

rank_tbl:
-----------------------------
RANK_NB	 RANK_NAME
1		 Low						   
2		 Medium
3		 High
-----------------------------

Let's say that I want to diaplay data from info_tbl but instead of having numbers for the filed RANK I want to display RANK_NAME that is from another table. How to do this ?

Edited April 19, 2006 by army20

[Dutchdre]

Something like this?

SELECT info_tbl.NM_PK, rank_tbl.RANK_NAME, info_tbl.NAME
FROM info_tbl INNER JOIN rank_tbl ON info_tbl.RANK = rank_tbl.RANK_NB;