rest - Inner Join and Outer Join In Odata -

rest - Inner Join and Outer Join In Odata -

i ma trying consume info odata service. want know there concept of inner , outer bring together in odata?if not, there way carry out same.

customerid----------------------customername 1 -----------------------------------alfreds futterkiste 2------------------------------------ana trujillo 3 ---------------------------------- antonio moreno

and selection "orders" table:

orderid--------customerid

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

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

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

output should in case of outer join---

name-------------------------------orderid

alfreds futterkiste-----------------null

ana trujillo------------------------10308

antonio moreno----------------------null

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

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

what odata url case?

for odata v4.0, there extension info aggregation, in cross-join concept presented.

rest join odata inner-join outer-join