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

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