ASA SQL User's Guide
Joins: Retrieving Data from Several Tables
Joins overview
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 Conversion when using comparison operators.