<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>Hi,</div>
<div>I am trying to join two layers using the DB Manager.</div>
<div>One layer is a shape file, one is a pure attribute table without geometry.</div>
<div>I have two fields that are identical in both layers, which should be used for the join.</div>
<div> </div>
<div>The SQL statement goes like this:</div>
<div> </div>
<div>SELECT *<br/>
FROM 210914_Joined_Ebenheit as a, 20210914_sqlbatch_20220315_161846_erfassungsdaten as b<br/>
WHERE<br/>
a.Filename = b.Filename AND<br/>
b.frameNr = b.Frame;</div>
<div> </div>
<div>What I get is the following error message:</div>
<div> </div>
<div>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"</div>
<div> </div>
<div>I don't get the meaning of "unrecognized token" - What I am doing wrong?</div>
<div>I have "Load as new layer" ticked on - I want a new layer.</div>
<div> </div>
<div>Any help appreciated!</div>
<div> </div>
<div>Regards,</div>
<div>Roland</div></div></body></html>