I have 2 tables: "ROBOTS" and "REFERRALS"Each table has a column called "IP"I want to run a query that removes all of the "IP" addresses in REFERRALS that are in the "IP" list in ROBOTS.What I have tried so far is:
SELECT REFERRALS.IPFROM REFERRALSWHERE REFERRALS.IP<>ROBOTS.IP;
I am very new to SQL so I'm hoping this is an easy thing to do?