je ne comprends pas ou ca bloque...

[fabien fab]

Bonjour,

Est- ce que ququ'un peut me dire ou est l'erreur je ne suis pas vraiment un expert...

delete from ndonnees a
where (a.dated is null or a.datef is null)
and exists
(
select 1 from ndonnees b
where a.njob= b.njob
and a.chaine = b.chaine
and b.dated is not null
and b.dated is not null
and b.id > a.id
)

Error: 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 'where (a.dated is null or a.datef is null)
and exists
(
select 1 from ndonne' at line 2 (State:37000, Native Code: 428)



merci