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

  • May 1, 2008 at 3:08 pm

    #809831

    Check this..

    delete PE

    from #prodextend as PE

    where exists (SELECT 1 FROM #product PT

    INNER JOIN #manu_clients MC

    ON PT.client = MC.clientcode

    WHERE PE.Din = PT.Din and PE.Pkgsize=PT.pkgsize )