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?