Tu ne peux pas utiliser de LEFT JOIN directement avec DELETE, mais tu dois pouvoir utiliser une table dérivée avec un DELETE multi-table comme ça:
[code]DELETE p.*
FROM (
SELECT products.products_id
FROM products
LEFT JOIN products_description USING (products_id)
WHERE products_description.products_id IS NULL
) AS p2, products p
WHERE p.products_id = p2.products_id[/code]

J'ai donc essayé :

requête SQL:

[code]DELETE FROM products WHERE products.products_id IN (

SELECT products.products_id
FROM products
LEFT JOIN products_description ON products_description.products_id = products.products_id
WHERE products_description.products_id IS NULL
)[/code]

MySQL a répondu:

[i]#1093 - You can't specify target table 'products' for update in FROM clause [/i]

idem pour

requête SQL:

[code]DELETE FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id WHERE products_description.products_id IS NULL
MySQL a répondu: [/code]

[i]
#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 'LEFT JOIN products_description[/i]

et ça ?
[code]DELETE FROM products
LEFT JOIN products_description
ON products_description.products_id = products.products_id
WHERE products_description.products_id IS NULL[/code]

A+

Pascal

Alors tu devrais pouvoir faire une requête imbriquée du style [code]DELETE FROM table WHERE champ IN (SELECT etc...)[/code]

mysql 4.1 :)

Quel SGBD et quelle version ?

je cherche a nettoyer une table [i]products [/i] des tuple qui non aps de concordance dans une table liée [i]products_description [/i], voici ma requete select qui me renvoie les tuples orphelins masi comment faire pour transformer ce select en delet ???


[code]SELECT *
FROM products
LEFT JOIN products_description
ON products_description.products_id = products.products_id
WHERE products_description.products_id IS NULL [/code]