Re: ERROR: missing FROM-clause entry for table on postgresql 8.1 not on 7.4; deleting from a join

F

How about something along these lines:


delete from instancetable
USING imagelevel
WHERE (
   (imagelevel.serparent= '1.2.840.113704.1.111.4640.1185891989.4') and
   (instancetable.imageuid= imagelevel.sopinsuid)
)

Thank You so much!! It works perfectly!!!!!

1. Where is this documented, and 
2. where can I read more about what changed
between the 7 series and 8 series that caused this?

Thank you so much!!!!!!!!!
Mitchell