Skip to Content
0
May 02, 2020 at 03:33 PM

How to performing a Join using CQN using fluid node.js notation

707 Views

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