oracle8.1.6 select count(*) from dotlrn_users where dotlrn_users.type = :type select count(*) from persons where not exists (select 1 from dotlrn_users where dotlrn_users.user_id = persons.person_id)