1 Reply Latest reply on Feb 20, 2015 5:59 AM by haxtbh

    Help with a update query from a subquery

    sdettling222 Level 1

      Hello All,

       

      I wanted to see if someone can help me with an update query.

       

      I need to grab a latitude & longitude from a the same user that is in two accounts. therefore i am trying to update lat/long in a users table for one account based off of the same user in another account. I am matching the users up by phone number and last name. I tried a subquery but am having difficulty.

       

      I was thinking of something like the following:

       

      update users

      set lat = getlat, long = getlong

      inner join (select lat as getlat, long as get long from users where account_id = '1')

      on phone = phone and last name = lastname

      where account_id = '2' and lat IS NULL and long IS NULL

       

      Am I going in the right direction???

       

      Thanks in advance for any assistance!!!!