[Qgis-user] query for Virtual Layer in relation to another layer

[Jürgen E. Fischer]

Moin Uwe,

On Fri, 04. Nov 2022 at 13:59:35 +0100, Uwe Fischer wrote:
> great - it works as expected!! Thank you!
> How can I find out about the engine that is used and the SQL syntax for
> virtual layers? I'd like to learn about it to be able to build more queries
> like this one.

Well, || is the standard syntax, but there are probably also databases that
will take + to concatenate strings too.  It's SQLite:

https://docs.qgis.org/3.28/en/docs/user_manual/managing_data_source/create_layers.html#supported-query-language

14.2.5.2. Supported query language

The underlying engine uses SQLite and SpatiaLite to operate.


Jürgen
 
-- 
Jürgen E. Fischer           norBIT GmbH             Tel. +49-4931-918175-31
Dipl.-Inf. (FH)             Rheinstraße 13          Fax. +49-4931-918175-50
Software Engineer           D-26506 Norden            https://www.norbit.de
QGIS release manager (PSC)  Germany                 IRC: jef on Libera|OFTC
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20221104/f0adc50f/attachment.sig>