The CData SSIS Components for ShipStation 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 CP.CarrierCode, CP.Code, CP.Name, CS.Domestic, CS.International, FROM CarrierPackages CP INNER JOIN CarrierServices CS ON CP.CarrierCode=CS.CarrierCode WHERE CP.CarrierCode='hermes'

Left Join

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

SELECT CP.CarrierCode, CP.Code, CP.Name, CS.Domestic, CS.International, FROM CarrierPackages CP INNER JOIN CarrierServices CS ON CP.CarrierCode=CS.CarrierCode WHERE CP.CarrierCode='hermes'