Inner join transform in mixed data source pick only one joined row

Like I said I am using mixed data sources, it means both tables are in different databases, so I cannot join them in same query. thanks