title: Inner Join and Outer Join In Odata
body: <p>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.</p>
  
  <p>CustomerID----------------------CustomerName<br>
  1 -----------------------------------Alfreds Futterkiste<br>
  2------------------------------------Ana Trujillo<br>
  3   ---------------------------------- Antonio Moreno   </p>
  
  <p>And a selection from the "Orders" table:</p>
  
  <p>OrderID--------CustomerID</p>
  
  <p>10308------------------2</p>
  
  <p>10309-----------------37</p>
  
  <p>10310----------------77</p>
  
  <p>Output should be in case of Outer Join---</p>
  
  <p>Name-------------------------------OrderId</p>
  
  <p>Alfreds Futterkiste-----------------null</p>
  
  <p>Ana Trujillo------------------------10308</p>
  
  <p>Antonio Moreno----------------------null</p>
  
  <p>null--------------------------------10309</p>
  
  <p>null--------------------------------10310</p>
  
  <p>What will be OData URL for this case?</p>