Home Forums SQL Server 2008 T-SQL (SS2K8) Two from clause in DELETE statement -- issue RE: Two from clause in DELETE statement -- issue

  • April 19, 2015 at 11:34 am

    #1791883

    DELETE Top(100000) FROM [dbo].[EncounterSignOff]

    FROM [dbo].[User] INNER JOIN [dbo].[EncounterSignOff] ON [User].[UserID] = [EncounterSignOff].[UserId]

    WHERE [User].PracticeID = '55';

    It works perfectly.