AnsweredAssumed Answered

Oledb Archive Delete statement with Join?

Question asked by ryland Champion on Nov 19, 2015
Latest reply on Nov 27, 2015 by bodo

Does anyone know if there is a way to run a delete statement that has a join?  I've tried the T-SQL equivalent and it is not working.

 

delete p

FROM piarchive..picomp p

inner join piarchive..picomp p1 on p.tag= p1.tag and p.time = (p1.Time + '1s')

Where

p.tag like 'LS%EOS%'

and p.time >= '*-1d'

 

[SQL Parser] [Line 3] Syntax error near 'FROM'.

 

The Select equivalent definitely returns the rows I would like to delete, I just can figure out how  to delete them.

 

Many Thanks!

Outcomes