DELETE with INNER JOIN

• Larsi1971

  Ten Centuries

  Points: 1081

  More actions

  February 4, 2004 at 5:36 am

  #107255

  Hello!

  Is it possible to have a delete syntax in sql with inner join inside it? it's possible in access - so I can't make it work in SQL. Am I right about this one.

  Here is the Access syntax - was hoping anyone could help me to do this in SQL!

  sSQL =

  "DELETE PIPES.*, ITEM.SWCode FROM ITEM INNER JOIN PIPES ON (ITEM.ItemNo = PIPES.iPartID) AND (ITEM.SWCode = PIPES.sPostID) WHERE (((ITEM.SWCode)='"+sPostID+"'));";

  
  -Lars
  
  Please only reply to this newsgroup. All mails would be bounced back.

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  February 4, 2004 at 5:55 am

  #492737

  DELETE Pipes

  FROM Item a INNER JOIN Pipes b

  ON a.ItemNo = b.IPartID

  AND a.SWCode = b.SPostID

  WHERE a.SWCode = @Variable

  This will delete from pipes all the records that exists on both tables.