Hi.
What would the equivalent CQN be for the following SQL statement and how would one write it using fluid node.js?
//Retrieve all persons with role 'C'
SELECT Persons.*
FROM Persons join Person_Role
on Person_Role.parent_id = Persons.ID
WHERE Person_Role.role = 'C';
The documentation (https://cap.cloud.sap/docs/node.js) doesnt seem to cover joins.
Regards
Sergio