DELETE * FROM [Shelby].[GFHstDet] INNER JOIN [Shelby].[GFHstDet] ON [Shelby].[GFHst].Counter = [Shelby].[GFHstDet].HstCounter WHERE [Shelby].[GFHst].[BatchNu] = 34986; DELETE * FROM [Shelby].[GFHst] WHERE [Shelby].[GFHst].[BatchNu] = 34986;