I´m trying to connect (through a line) every id point from dataset 01 with its associated ids in the dataset 02.
In the code below, every point in the dataset01 is linked with all points in dataset02, but i´m trying to solve how i can connect each id in dataset01 with just its ids, for example: 8888888 id from dataset01 will be linked with all 8888888 id points from dataset02, etc
id, lat, long 8888888, x1, y1 9999999, x2, y2
id, lat, long 8888888, x1.1, y1.1 8888888, x1.2, y1.2 8888888, x1.3, y1.3 8888888, x1.4, y1.4 9999999, x2.1, y2.1 9999999, x2.2, y2.2 9999999, x2.3, y2.3
SELECT ST_MakeLine( d2.the_geom_webmercator, d1.the_geom_webmercator) AS the_geom_webmercator, ceil( ST_Distance ( d1.the_geom_webmercator, d2.the_geom_webmercator) ) as distance FROM dataset02 as d2, dataset01 as d1