select RawHits.Hostaddy from RawHits LEFT JOIN ExclHost on RawHits.Hostaddy LIKE ALLTRIM(ExclHost.Hostaddy) WHERE ExclHost.hostaddy IS NULL