Why is it not a good idea to join on columns with different data types?

Because there'll be no match and we won't get any results.