Left join brings NULL values

[jutu]

Hi. I have joined the 3 attached spreadsheets in Power BI but no joy as it gives me null values in the Acc. Mgr, Product_ID and Region fields not sure why.

I have tried it in SQL using left join, same as in Power BI. Also tried full join but brings more columns, as it should. Thank you


select
*
from [Task.Transactions] as TR
Left join [Task.Account_owner7] as AO
on TR.Partner_ID = AO.Account_Manager
Left join [Task.Price_list10] as PL
on TR.Product_ID = PL.Product_ID
ORDER BY AO.Account_Manager

 

[GraH - Guido]

Without possibility to open any of your files for the moment. Common reasons may be:
- fields on both ends are of a different data type
- case settings are different.
Did you exclude these already?

 

[p45cal]

on TR.Partner_ID = AO.Account_Manager

I'm not a SQL aficionado but from what I can tell:
TR.Partner_IDs looks like:

Partner_13​

Partner_2​

Partner_4​

Partner_16​

Partner_12​

and AO.Account_Managers look like:

Account_Manager_1​

Account_Manager_2​

Account_Manager_3​

Account_Manager_4​

Account_Manager_5​

and there are no matches.

maybe that part should read:
on TR.Partner_ID = AO.Partner_ID

I await to be shot down in flames…