This blog shares my journey as a software engineer, along with personal reviews and life experiences I’ve gained along the way. “I have not failed. I've just found 10,000 ways that won't work.” — Thomas Edison. If you enjoy my content, please support it by clicking on ads (free for you, big help for me!) or by buying me a coffee on Ko-fi. Thank you!
Thursday, June 21, 2007
Update from comparison of two SQL tables
UPDATE o SET Amount=Price FROM orders o JOIN items i ON (o.ItemNumber=i.ItemNumber)
UPDATE o SET EmpActive = 0 FROM ComplianceEmployee o JOIN ComplianceEmployeeLoad i ON (o.EmpID = i.EmpID)
No comments:
Post a Comment