Using JOIN with DELETE

• texpic

  SSCertifiable

  Points: 5885

  More actions

  November 5, 2006 at 9:01 am

  #94815

  Is there a way to do this?  Seems like I can't join a table when I want to delete.  Thanks!!!

  DELETE

  FROM _FinalTrans A

  INNER JOIN _FinalFlat B

  ON A.AcctNo = B.AcctNo

  WHERE B.Tagged <> 0

  AND B.SupervisorMark = 0

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  November 5, 2006 at 11:22 am

  #669978

  DELETE A

  FROM _FinalTrans A

  INNER JOIN _FinalFlat B

  ON A.AcctNo = B.AcctNo

  WHERE B.Tagged <> 0

  AND B.SupervisorMark = 0