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.