Mysql join tables not equal values
I wanted to join two tables and get the uncommon results or values between the two. I tried join statement but apprently that does not do the trick, use the following if you have such a requirement:
select * from a wheret id not in (select tid from b)