Hi,
I am trying to join two layers using the DB Manager.
One layer is a shape file, one is a pure attribute table without geometry.
I have two fields that are identical in both layers, which should be used for the join.
The SQL statement goes like this:
SELECT *
FROM 210914_Joined_Ebenheit as a, 20210914_sqlbatch_20220315_161846_erfassungsdaten as b
WHERE
a.Filename = b.Filename AND
b.frameNr = b.Frame;
FROM 210914_Joined_Ebenheit as a, 20210914_sqlbatch_20220315_161846_erfassungsdaten as b
WHERE
a.Filename = b.Filename AND
b.frameNr = b.Frame;
What I get is the following error message:
Query execution error on CREATE TEMP VIEW _tview AS SELECT * FROM 210914_Joined_Ebenheit as a, 20210914_sqlbatch_20220315_161846_erfassungsdaten as b WHERE a.Filename = b.Filename AND b.frameNr = b.Frame: 1 - unrecognized token: "210914_Joined_Ebenheit"
I don't get the meaning of "unrecognized token" - What I am doing wrong?
I have "Load as new layer" ticked on - I want a new layer.
Any help appreciated!
Regards,
Roland
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
