The CData Cmdlets PowerShell Module for Microsoft Dynamics NAV supports standard SQL joins like the following examples.

Inner Join

An inner join selects only rows from both tables that match the join condition:

SELECT Customer.Name, SalesOrder.Document_No FROM Customer, SalesOrder WHERE Customer.No=SalesOrder.Sell_to_Customer_No

Left Join

A left join selects all rows in the FROM table and only matching rows in the JOIN table:

SELECT Customer.Name, SalesOrder.Document_No FROM Customer LEFT OUTER JOIN SalesOrder ON Customer.No=SalesOrder.Sell_to_Customer_No