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.