Inner Join and Outer Join In Odata

Question

I ma trying to consume data from an OData Service. I want to know Is there any concept of inner and outer join in OData?If not, is there any way to carry out the same.

CustomerID----------------------CustomerName
1 -----------------------------------Alfreds Futterkiste
2------------------------------------Ana Trujillo
3 ---------------------------------- Antonio Moreno

And a selection from the "Orders" table:

OrderID--------CustomerID

10308------------------2

10309-----------------37

10310----------------77

Output should be in case of Outer Join---

Name-------------------------------OrderId

Alfreds Futterkiste-----------------null

Ana Trujillo------------------------10308

Antonio Moreno----------------------null

null--------------------------------10309

null--------------------------------10310

What will be OData URL for this case?

Answer 1

For OData V4.0, there is an extension for data aggregation, in which the Cross-join concept is presented.