I am having trouble getting this to run... can anyone help me out?
I get this error: ORA-00933: SQL command not properly ended
and points to the INNER word in red below

delete from table1 a
inner join table2 s
on a.ponbr = s.ponbr
inner join table3 h
on a.ponbr = h.ponbr
inner join table4 n
on a.ponbr = n.ponbr
where a.revnbr < h.revnbr
or (a.revnbr = h.revnbr
and a.date < n.date
and (a.itemnbr = n.itemnbr and a.name = n.name));


Any ideas??

it appears your version of Oracle does not ANSI syntax so convert SQL to non-ANSI syntax

Doesn't 10g support Ansi sytax? That is the database version that is currently being used.

>Doesn't 10g support Ansi sytax?
In theory V10 is supposed to support ANSI syntax.
In reality the error indicates otherwise; at least for DELETE.
You are free to submit Service Request to MOS, for official resolution.
In the mean time, if you desire to proceed, I suggest you work around the error as best you can

Ok thank you!