Select Update Query Help - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Select Update Query Help

Author

Topic

mshsilver
Posting Yak Master

112 Posts

Posted - 2010-04-07 : 10:59:20

Hi,

I have a query that joins two tables and takes the client_id from both tables and displays them next to each other.

What I need to do based on my WHERE clause is update the q.client_id with the values in c.client_id and trying to build a query to do that is doing my brain in.

Can anyone shed some light on the best way to achieve this? I would display all my failed attempts but that might not be helpful

Thanks for looking.



select c.company,q.createtime, Q.emp_FIRST_NAME, q.emp_lastname, q.client_id, c.client_id as contact_client_id from wce_contact c inner join wce_qualifications q on c.uniqueid = q.entityid where not c.client_id = q.client_id

mshsilver
Posting Yak Master

112 Posts

Posted - 2010-04-07 : 11:05:53

I just figured it with some help.

This is what i needed



Update q
Set    q.client_id = c.client_id
From   wce_contact c 
       inner join wce_qualifications q 
         on c.uniqueid = q.entityid 
where  not c.client_id = q.client_id

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources