What happens when we join tables on columns that have different data types?

We get an empty result tableWe get all rows from both tablesWe only get rows from one of the table

We get an empty result table.