I am experiencing difficulties with SQL syntax in a Virtual Layer. I can do the simplest query form such as:
SELECT * FROM mytable
and this displays on my canvas.
However, if I try to name fields in my table such as:
SELECT field1, field2 FROM mytable
this doesn't create an error but does not display on my canvas.
Can anyone offer suggestions, please? I have tried it on several layers.