Colin Wetherbee wrote:
SELECT connect(p_start.location, p_end.location) FROM foo JOIN points AS p_start ON foo.point_id_start = points.point_id JOIN points AS p_end ON foo.point_id_end = points.point_id WHERE foo.id = 8192;
As I didn't test this code, my syntax was slightly incorrect. JOIN ... ON ... = p_start.point_id JOIN ... ON ... = p_end.point_id Colin
