Arithmetic overflow error converting expression to data type int' - left join on 2 SQL tables

[Phoenix_Bird]

I've getting this ' Arithmetic overflow error converting expression to data type int' error when I try to do a left join of 2 SQL tables.

I can pull both tables in individually with no issue using a SQL statement but when I try to do a left join I get this error. 

As far as I can tell, the data type of the fields I'm using to create the join is the same (whole number). 

Any ideas if I can get around this issue in my SQL statement?

[v-xiaotang]

Hi @Phoenix_Bird 

May be there are something wrong with your data. Could you take a test on simple data with the same left join SQL statement and same data type?  Then judge where the problem is by the result. Or could you add more details? so that we can work on it further.

If you are in a hurry to use data after left join and currently can’t solve this problem, you can use the function Merge Queries in Power Query Editor to process data as an alternative after pulling both tables in individually.

Hope it helps!

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Probably - hard to tell without sample code.