SQL to update xy of A to xy of B

[katy_wallis]

My SQL is rusty and I cant remember how to do this. I have meters that are geocoded to the parcel centroid and I

need the SQL statement to move them to the correspoding XY of the GPSed points.

I know there is a statement that goes something like
     Update coordinate x of MeterPoint to x of GPSpoints
      where MeterID of MeterPoint = MeterID of GPS points

Can anyone out there help me out Please?

Thanks
Kathy

[RobertScheitlin__GISP · Accepted solution]

Katy,

   Sure something like this:

UPDATE MeterPoint

SET [coordinate x] = toX, [Coordinate y] = toY,

WHERE MeterID = MeterIDvalue;

MeterPoint = the table name

[coordinate x] = the column name

MeterID = the column name

[katy_wallis]

Robert - thank you so much for your quick reply. You save me a lot of time trying to figure this out.