SQL & PL/SQL :: Alternative For Not In

I've got to create 2 tables...

Table 1 include members of a certain club with specific criteria
Table 2 needs to include everyone else on the main database, not in the club, but with the same criteria.

So, ultimate goal is to have two tables, similar criteria, T1 = club members and T2 = non-club members

Table 1 ran just fine.

Table 2 is running and running and running. I'm looking for a more efficient way then the syntax below:

create table NON_club_Members nologging as
select distinct hcp.ID, count (distinct hcp.profile_key)
from mrtcustomer.table_1 hcp, Club_Members cm
where hcp.child_birth_dt between '31-OCT-2000' and '30-OCT-2011'
and hcp.ID not in
(select cm.id from Club_Members)
group by hcp.id

I've also tried <> and that also ran and ran and ran.