I am trying to update a table B geom column with the coordinates from table A.Table A having coordinates in two separate columns x and y.Table B to have the coordinates from Table A into Table B's geom spatial column.
Table A and B have an ID in common for each record.
I usually use FME to do this but this time I'd like to do it using pure SQL.
Any suggestions on how to do it?
أكثر...
Table A and B have an ID in common for each record.
I usually use FME to do this but this time I'd like to do it using pure SQL.
Any suggestions on how to do it?
أكثر...