I have a spatialite point table (
p1) with an additonal column (
pid) that relates each point to a point in another point table (
p0) in the same database. I want to create a line between every pair of points where
p0.id. This is a 1:1 relation.
How can I do that in spatialite or in QGIS 2.14?