|
Aqui esta pero veremos si te ayuda ok:
SELECT CONCAT(a.options_id,' ', a.options_values_id),
CONCAT(b.options_id,' ',b.options_values_id), CONCAT(c.options_id,' ',c.options_values_id)
FROM atributos a INNER JOIN atributos b INNER JOIN atributos c
WHERE ((a.options_id<>b.options_id) AND (a.options_id<>c.options_id) AND (b.options_id<>c.options_id))
AND ((a.options_id = 'Color') AND (b.options_id = 'Talla') AND (c.options_id = 'Tela'))
ORDER BY 1,2,3
|
