I'm trying to remove second table entries that matches in first table but confused
here is my SQL
members.id as ID
(members.membership_accepted=1 AND members.full_membership=1)
It shows me members table with all of its entries. If i use INNER JOIN then it shows just the matches entries from both table. but don't know how I can get my required results.