SQL Subqueries
Subject:   Help with subquery please
Date:   2008-04-16 08:45:26
From:   Viraco
select a.purchaser_id, a.account_name
from account a, user_application_access b
where a.purchaser_id=b.constraint_value
and a.country_code in ('US','CA')
and 'UADM' not in (
select distinct c.application_id
from user_application_access c
where c.constraint_value=a.purchaser_id
order by a.purchaser_id

when run in asp code it returns no results, when run a sql query application it hourglasses