hi there,
i think i hav a pretty simpleproblem but i dont know how to solve this.
imagine, i have 2 fields in a table, each representing one traffic
light. for the possible colors a have another table. so here are the
tables and thre content:
color:
id color
1 red
2 yellow
3 green
trafficlight:
id idColor1 idColor2 someOtherColumn
1 2 3 sometext
2 3 3 sometexttoo
3 3 1 somemoretext
: : : :
this means entry 1 in the trafficlight-table means that one light is
yellow while the other one is green.
what i want to do is a select wich gives me all records of the
trafficlight-table but instead of the numbers i want to see the
colornames. i mean the result of the select-statement should look like:
selectstatement:
someOtherColumn Light1 Light2
someText yellow green
someTextToo green green
someMoreText green red
see what i mean? sorry, i know it was quite a lot text to read but i
dont know how to write this shorter.
