Hi All,
I am trying to expose the JOIN of 2 CDS entities on the service layer based on a condition,but I am not getting the syntax right.
Please find below the code snippet:
service DataService {
entity A as projection on x.A;
entity B as projection on x.B;
entity C as (SELECT from x.A {*} JOIN (SELECT from x.B {*}) ) on x.A.Id = x.B.Id; //NOT RIGHT
}
How do I fix the entity C syntax?
Thanks & Regards,
Harish