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

  • July 23, 2012 at 2:02 am

    #1516091

    Hi vikash,

    In my case I want to delete those data which is not selecting in below join any Help..

    DELETE ord FROM Orders ord INNER JOIN Customers c(nolock) ON ord.CustomerID = c.CustomerID WHERE c.FirstName = 'vikash'

    Thanks