Can anyone help me? I am trying to update a second table with criteria in its own and another table being set. This is what I have come up with and various others. It should give an idea of what I am trying to do.
LEFT JOIN Clients ON Clients.ClientRef = ClientExtraDetails.ClientRef
SET ClientExtraDetails.UserDefinedKey1 = 'bro'
WHERE Clients.ClientType = 70
AND ClientExtraDetails.UserDefinedKey1 is NULL
Any help would be great.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!