Jump to content

SQL Query Help


Recommended Posts

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 by army20
Link to comment
Share on other sites


Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...