Select values that match

[zzz]

I have two tables: t1 and t2.

Each one contains IP addresses.

t1 has unique addresses
t2 has a lot of duplicates

I need to be able to select unique IP addresses from t2 that are not present in t1.

Not sure how that is done.

[laserlight]

If you can use subqueries you could execute:

SELECT DISTINCT ipaddr FROM t2 WHERE ipaddr NOT IN (SELECT ipaddr FROM t1)

[zzz]

Yep, this is how I ended up doing it. Thanks!