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