Problems with Subselect

Hello guys,
i am trying to implement a Subselect via Query Studio, but i cannot find a solution with the MetaSQL compoment.

the statement should be something like that:

SELECT *
FROM ADR
INNER JOIN
(SELECT AdLfdNr, ZwST
FROM ADRSEL
WHERE ADRSEL.Seid = 'AKBEJ') AS ADSEL ON ADR.AdLfdnr = ADSEL.AdLfdNr
                                      AND ADR.ZwST    = ADSEL.ZwST

is there any way to implement subselects?

kind regards

Udo Gwiasda

Hello Udo,


Unfortunately no, only regular tables are allowed in MetaSQL FROM clause...