grazie Funziona benissimo

passo la query magari potrà essre d'aiuto a qualcuno

SELECT nome, C1.colore AS colore1, C2.colore AS colore2, C3.colore AS colore3
FROM ColorClr AS C1, ColorClr AS C2, ColorClr AS C3, test
WHERE test.id=1 AND colore1=C1.id_color AND colore2=C2.id_color AND colore3=C3.id_color

ciao