Home Forums SQL Server 2005 T-SQL (SS2K5) DELETE using INNER JOIN RE: DELETE using INNER JOIN

  • May 2, 2008 at 5:09 am

    #809989

    Hi,

    try this

    DELETE px

    FROM #prodextend px

    INNER JOIN #product p ON p.din = px.din

    AND p.pkgSize = px.pkgSize

    INNER JOIN #manu_clients mc ON mc.clientCode = p.clientCode

    Regards

    Rajat 🙂