I have two tables t1 and t2. t1 contains all my customer info:name, address, email, etc... t2 is my email optin list. I used INNER JOIN to combine the tables where the email addresses are the same. However, I can't get it to work for some reason. Here is my SQL that I have tried:
SELECT t2.email, t1.name, t1.address FROM t1 INNER JOIN t2 ON t1.email = t2.email;
It returns 0 rows, but I have looked through the data and I see matching email address in both tables, so I am not sure why it isn't working. Any idea?