We want to execute in PQL the following SQL code:
SELECT SUM (BD2.betkortbedr), BD2.Crediteur
FROM BSAK_DEF2 BD2
INNER JOIN LFA1_BEW_CSV LFA ON BD2.Crediteur = LFA.Crediteur
WHERE LFA.Flinqer IS NULL AND (BD2.Korting1 > 0)
GROUP BY BD2.Crediteur
But the join is not fully discribed in the PQL documentation.
Does anyone have a sugestion how to solve this with PQL?
Hi Jacob,
in PQL all tables are implicitly joined as Outer Left Join. You can find the related
article in the documentation:
https://help.celonis.cloud/help/display/CIBC/Join+functionality
To achieve your request, you have to create the Inner Join by using the implicit Outer Left Join and applying a filter, to remove all entries without join partner. Here is an example that describes how to do this.
Does this help you?
Cheers,
Max
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
