Post reply

Using JOIN with DELETE

  • 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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply