bonjour
je ne comprends pas pourquoi j'ai une erreur de syntaxe sur FULL OUTER JOIN
voici ma requete
select * from products p left join products_description pd on p.products_id=pd.products_id FULL OUTER JOIN specials s on s.products_id=pd.products_id where (p.products_model_f REGEXP '(ral_|ral-)') and (p.codeF !=2 and p.codeF !=11 and p.codeF !=12 and p.codeF !=13) group by p.products_id order by p.products_model
et voici l'erreur
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 'FULL OUTER JOIN specials s on s.products_id=pd.products_id where (p.products_mo' at line 1
merci pour votre aide
Partager