sql - Getting nearest line to point with virtual layer using QGIS?

I have a streetmap and the position of hundred sensorlocations. I am currently trying to calculate the nearest line for each point. I have already done it with the nnjoin plugin. But now I want to do this with a virtual layer. For this, I followed the tutorial: https://pigrecoinfinito.wordpress.com/2017/04/28/qgis-minima-distanza-tra-punti-e-linee/

But unfortunately, I could not get it to work because I am very new to SpatiaLite. To create the virtual layer, my approach looks like followed:

If I want to test this query, I am getting the following error note:

Any suggestions on how to fix this?

---

I have know tried it with renamed tables, but I am still getting the same error message.

Maybe something more is wrong?