Roubicek

Thank you Sidesh, that worked brillantly.

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?