The Database Forum

**dNoopy** · 05:36 PM

I have two tables like the below.

Code:

jewelry

(id) jewel
(1)   diamond
(2)   "gold"

jewels

(jewel1)  (jewel2)
(1)         (2)

The result of the code1 below outputs diamondRelated (2).

Code:

code1

SELECT
jewel2 as diamondRelated
FROM jewels
left join jewelry on id=jewel1
WHERE
jewel="diamond"

I like to output diamondRelated with the word "gold" instead of the number (2).

The result of the code2 below outputs diamondRelated diamond instead of "gold".

Code:

code2

SELECT
jewel as diamondRelated
FROM jewels
left join jewelry on id=jewel1
WHERE
jewel="diamond"

The code3 below is another trial.
Since I add left join jewelry on id=jewel2 for connecting (2) to "gold",
It causes an ERROR.

Code:

code3

SELECT
jewel as diamondRelated
FROM jewels
left join jewelry on id=jewel1
left join jewelry on id=jewel2
WHERE
jewel="diamond"

**chrishirst** · 01-14-2011, 02:27 PM

I'd suggest a decent SQL tutorial would be a good idea.

left join jewelry on id=jewel2

should probably be

left join jewelry on jewel.id = 2

assuming I have worked out what you actually want to do