Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> DELETE statement with a JOIN
Hi. I'm trying to convert this small piece of SQL 2000 code to Oracle
8i.
From what I gather in the news groups, you can't delete on a Join. So what should I do for this specific case?
DELETE DESCHYPLIST
FROM DESCHYPLIST DHL JOIN TPLDESCLIST TDL ON (DHL.FKINFO = TDL.FKINFO)
WHERE FKTEMPLATELIST = @FkTmpl and FKLIST = @PkList
Received on Fri Jan 16 2004 - 15:03:23 CST
![]() |
![]() |