Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> DELETE statement with a JOIN

DELETE statement with a JOIN

From: Jeff Lambert <jeffl_at_hypershell.com>
Date: 16 Jan 2004 13:03:23 -0800
Message-ID: <f17e7766.0401161303.d4eddaf@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US