deleting a record with join condition
DELETE dbo.Candy
FROM dbo.Candy INNER JOIN dbo.CandyReport
ON Candy.CandyReportId = CandyReport.CandyReportId
WHERE CandyReport.CandyId = @CandyId
DELETE dbo.CandyReport
WHERE CandyReport.CandyId = @CandyId</p>
FROM dbo.Candy INNER JOIN dbo.CandyReport
ON Candy.CandyReportId = CandyReport.CandyReportId
WHERE CandyReport.CandyId = @CandyId
DELETE dbo.CandyReport
WHERE CandyReport.CandyId = @CandyId</p>
사실 그렇게 어려운 건 아니지만, 그래도 tip으로.
Comments