vozmozhno li poluchit?

have some tables :
v 1 hranitsa kucha dannich(height,weight,color...),no ne text a numbers,toest:

table: personal
field: height weight color
value: 1 12 8

i est tables gde zapisano sootvetstvie text=number:

table: colors

field: id_color color_name
value 1 red
2 blue

i tak dalee.

vopros:kak pri zaprose SELECT * FROM personal....
poluchit vmesto numbers ---> text.

spasibo.

SELECT h.height_name, w.weight_name, c.color_name FROM personal p
inner join colors c on p.color=c.id_color
inner join heights h on p.height=h.id_height
inner join weights w on p.weight=w.id_weight

0