[Qgis-user] Select by Expression with Subquery

[Altergott, Randy (CCI-Southwest)]

Hi QGIS users,
I'm new to QGIS and this is my first question.
Can I use QGIS "Select by Expression" to select all features in a vector layer where the "name" field value is also found within another layer (delimited text layer with no geometry)? I get a syntax error when using the following SQL.

"NAME" IN (SELECT "NAME" FROM 'LAYER2')

I'm using the "Map Layers" menu to add the layer name, so it actually displays something like 'LAYER2_ca36271a_8ec7_4aa7_a36c_67418104f66c' instead of just 'LAYER2'.

Thanks,
Randy

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190617/ce31d731/attachment.html>