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.
FROM piarchive..picomp p
inner join piarchive..picomp p1 on p.tag= p1.tag and p.time = (p1.Time + '1s')
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.