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