Select Update Query Help

  • 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

  • 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