Je sais que mes trois SELECT fonctionnent, le premier et le troisieme avec l'UNION fonctionnent mais quand je rajoute le SELECT du milieu avec mon minus...
Voila ce que me répond phpMyAdmin :
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MINUS SELECT s.name, c.name FROM assetclass_isesoftware AS s, assetclass_isecom' at line 5
Si vous pouviez m'aider..
Merci d'avance!
voici ma requete:
SELECT s.name, c.name
FROM assetclass_isesoftware AS s, assetclass_isecomputer AS c, dico_soft AS d
WHERE c.ID = s.HARDWARE_ID
MINUS
SELECT s.name, c.name
FROM assetclass_isesoftware AS s, assetclass_isecomputer AS c, dico_soft AS d
WHERE s.name = d.EXTRACTED
AND c.ID = s.HARDWARE_ID
UNION
SELECT d.FORMATTED, c.name
FROM assetclass_isesoftware AS s, assetclass_isecomputer AS c, dico_soft AS d
WHERE s.name = d.EXTRACTED
AND c.ID = s.HARDWARE_ID
ORDER BY 2 , 1