SQL Statement to update a table with set conditions on another table

5 pts.
Tags:
SQL
SQL statements
Hi, 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. UPDATE Clientextradetails 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.
ASKED: January 29, 2009  3:21 PM
UPDATED: January 29, 2009  7:06 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

You will want to use something like this.
<pre>
update Clientextradetails
SET ClientExtraDetails.UserDefinedKey1 = ‘bro’
FROM Clients
WHERE Clients.ClientRef = ClientExtraDetails.ClientRef
AND Clients.ClientType = 70
AND ClientExtraDetails.UserDefinedKey1 is NULL</pre>

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following