multiple fields issue!!

[Gillian]

Hi all:
I have a table having multiple fields, but this fields can have the same values as the folowing

Table 1
|----------------------------|
| Field1 | Field 2 | Field 3 |
|----------------------------|
| 1 | 2 | 1 |
|--------|---------|---------|
| 2 | 1 | 2 |
|----------------------------|


In another table, I put the description of the field like this

Table 2
|------------------|
| Field1 | Field 2 |
|------------------|
| 1 | One |
|--------|---------|
| 2 | Two |
|------------------|

i wana make the select statement showing the description of each field in the Table 1.

The output should be like this

|----------------------------|
| Field1 | Field 2 | Field 3 |
|----------------------------|
| One | Two | One |
|--------|--------- -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[domin]

try the following

SELECT t1.field2 AS Field1, t2.field2 AS Field2, t3.field2 AS field3
FROM table1 AS t0
JOIN table2 AS t1 ON t0.field1 = t1.field1
JOIN table2 AS t2 ON t0.field2 = t2.field1
JOIN table2 AS t3 ON t0.field3 = t3.field1; -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --