When you join two tables, the columns you compare must have the same or compatible data types.

For more information about data type conversion in joins, see Comparisons between data types.