Chandrashekar
2/9/2015 - 1:10 PM

Delete from inner join

Delete from inner join

Delete from inner join
content_copyfile_download
DELETE PME
		FROM [dbo].[ProductMappingToEmployee] PME
		INNER JOIN @tblProducts tbl ON PME.ProductId = tbl.ProductId
			AND PME.ProductSeriesId = tbl.ProductSeriesId
		WHERE PME.IsActive = 1
			AND PME.OrganizationId = @OrganizationId