Simple select question

Giganews Newsgroups
Subject: Simple select question
Posted by:  DBC User (dbcus…
Date: 5 Jun 2006

I have a master table, which has 3 columns which are integer values. I
have another reference table, which has integer to string translated,
could can I get the string representation of the integer for all 3
columns in a single query.

Example: Table A has
name, age, sex, ref1, ref2, ref3

a, 1, m, 1, 2, 3

Table B has
ref, description
1, one
2, two
3, three

I want the resultant to be
name, age, sex, description for ref1, description for ref2, description
for ref3
a,1,m,one,two, three