Ver originalSELECT * FROM productos AS pJOIN colores AS c1 ON (p.idcolor1=c.idcolor)JOIN colores AS c2 ON (p.idcolor2=c.idcolor)