The CData SSIS Components for SAP Cloud for Customer 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 AccountCollection.AccountName, AccountNotesCollection.Text FROM AccountCollection, AccountNotesCollection WHERE AccountCollection.ObjectID = AccountNotesCollection.ParentObjectID

Left Join

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

SELECT AccountCollection.AccountName, AccountNotesCollection.Text FROM AccountCollection LEFT OUTER JOIN AccountNotesCollection ON AccountCollection.ObjectID = AccountNotesCollection.ParentObjectID