 <ol> <li>The m. or t. are aliases for tables within your query (so you are probably using tables that begin with the letter m and t). The alias is specified after the table name in the FROM part of your query.</li> <li>The syntax looks off for your JOIN. The query should probably look more similar to this:</li> </ol> <blockquote> <p>SELECT DISTINCT t1.email, t1.status_type, t2.status_value_text<br> FROM [Table 1] t1 JOIN [Table 2] t2 ON t1.email = t2.email</p> </blockquote> <p>Check out this link to see more examples.<a href="http://www.w3schools.com/sql/sql_join.asp" rel="nofollow">http://www.w3schools.com/sql/sql_join.asp</a></p>