I'm trying to create a virtual layer in QGIS for use in QField using SQL, but cannot work out what the syntax is to refer to a GeoPackage layer.
My GeoPackage is named "survey". My GeoPackage layer is named "treePt".
I cannot get a simple SQL statement to work. I have tried the following:
select fid from "survey - treePt" select fid from 'survey - treePt' select fid from survey - treePt select fid from "treePt" select fid from 'treePt' select fid from 'reePt
All of which throw an error "Referenced table in query not found"
What is the correct syntax?