To run a simple interest query in Mapinfo I would use
Select * from _1_10000_map_sheet_key_map, Carpentaria_Shire where _1_10000_map_sheet_key_map.Obj Intersects Carpentaria_Shire.Obj into Selection
In QGIS in Add--Virtual Layer and in DB Manager I keep getting errors
select * from _1_10000_map_sheet_key_map where st_intersects (_1_10000_map_sheet_key_map.geometry, Carpentaria_Shire.geometry) as Selection
gives the following error
Query execution error on CREATE TEMP VIEW _tview AS select * from _1_10000_map_sheet_key_map where st_intersects (_1_10000_map_sheet_key_map.geometry, Carpentaria_Shire.geometry) as Selection: 1 - near "as": syntax error
The same from Virtual Layers and trying to use geom_from_wkt I get
Query preparation error on PRAGMA table_info(_tview): no such column: Carpentaria_Shire.geom_from_wkt
What's the expected structure of the query in QGIS SQL implementation?
Additionally can this be done in the Advanced Filter expression?