JOIN QueriesCData BizTalk Adapter for FedEx 2019 - Build 19.0.7354
The CData BizTalk Adapter for FedEx 2019 supports standard SQL joins like the following examples.
An inner join selects only rows from both tables that match the join condition:
SELECT p.ShipmentId, a.Email FROM Shipments p, Recipients a WHERE p.RecipientId = a.RecipientId
A left join selects all rows in the FROM table and only matching rows in the JOIN table:
SELECT p.ShipmentId, a.Email FROM Recipients a LEFT JOIN Shipments p ON p.RecipientId = a.RecipientId