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