Tuesday, December 31, 2019

Delete Data From Joining Tables

Delete ev   FROM Evaluation AS ev
Inner Join Employee AS e ON ev.EmployeeId = e.EmployeeId
 WHERE
 e.OfficeId IN ( SELECT OfficeId FROM Office WHERE ThirdLevel = 2790 AND IsActive = 1 )
 AND ev.Year = 2019
 AND ev.EvaluationPeriodShort = 'D'

No comments:

Post a Comment

Screen Record

 Windows Screen Record WindowsKey+ Alt + R Recording Starts.