-
Locating Duplicates from 2 Queries
I have one query below:
select magazine_name, season_letter
from magazine
where source = 'D1000'
and season_letter = 'A'
order by mag_name
I have a second query below:
select magazine_name, season_letter
from magazine
where source = 'D1000'
and season_letter = 'B'
order by mag_name
But I would like some help trying to figure out how to find the same mag_name from each query and I was thinking something around the line of below:
select mag_name
**some kind of exists in statement***
(query 1)
and in
(query 2)
Any help would be greatly appreciated
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
|
|