QGIS Virtual Layer makeline.sql

# Create a line to show the distance between points
# http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.2.0.html
# 'select EnableGpkgAmphibiousMode()' to enable sql query on geopackage

select
	cNewg.address,
	MakeLine(cNewg.geometry, cOldg.geometry) as geometry
from 
(select Newg.rue_txt || Newg.numero as address, Newg.geometry
 from Newg 
) as cNewg
join
(select	Oldg.rue_txt || Oldg.numero as address,	Oldg.geometry from Oldg
) as cOldg on cOldg.address = cNewg.address