-
combining query results
Good Evening,
I have the following query:
select distinct inc_cat_sc from inc_cat
that returns these results:
3RD PARTY CAUSE
ACCESS
ACCESS DENIED
APPROVE
AUTHORIZATION
I also have this query:
select inc_cat_sc from inc_cat where inc_cat_sc NOT IN
(select distinct
inc_cat.inc_cat_sc
from
inc_cat inner join incident on incident.cause_id = inc_cat.inc_cat_id
where
inc_cat.inc_cat_id <> 0)
That returns these results:
3RD PARTY CAUSE
ACCESS
Then I have a 3rd query:
select inc_cat_sc from inc_cat where inc_cat_sc NOT IN
(select distinct
inc_cat.inc_cat_sc
from
inc_cat inner join incident on incident.inc_cat_id = inc_cat.inc_cat_id
where inc_cat.inc_cat_id <> 0)
That returns:
ACCESS
ACCESS DENIED
I need a query that will give me all the values in the first query that are not in either the 2nd query or the 3rd query.
So the results I would be looking for are:
APPROVE
AUTHORIZATION
Any suggestions are greatly appreciated.
Thanks in Advance,
Di-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|