April 7, 2010 at 8:57 am
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
April 7, 2010 at 9:05 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply