I have two tables user_registration and user_subscription, first users get registers on the site and information goes into first table user_registration. Secondly users are made paid subscribers and the information goes into 2nd table user_susbscriptions.

Now i need a MySql query to fetch emails etc from table 1 who are just registered users not subscribed. How i can exclude the users who are subscribed and their user id exist in table 2. user id is foreign key in table 2.
How i can fetch the emails from table 1 who are just registers not subscribed. Please help me to make a query.

Thanks,
Shahnawaz

use a LEFT OUTER JOIN together with an IS NULL check on the joined column of the right table (to find the unmatched rows of the left table)

Or a NOT EXISTS/NOT IN subquery.

Dave