This statement is actually a test. I am really trying to select some records based on a NOT LIKE match in another table...

I can't use a NOT LIKE in my inner join because the logic is incorrect. I've thought of a hack, but like the subquery option if I could use LIKE in a subquery.

What I am really trying to do is :

SELECT rawhits.hostaddy FROM rawhits ;
WHERE NOT EXISTS (SELECT 1 FROM exclhost WHERE exclhost.hostaddy LIKE rawhits.hostaddy)