Article:  |
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
|
||
Women in Technology
Hear us Roar
