Multiple conditions on the same column in the WHERE clause
select PropertyVal
from your_table
where PropertyID = 7
and RecordID in
(
select RecordID
from your_table
where (PropertyID = 13 AND PropertyVal='Business Development Analyst')
or (PropertyID = 11 AND PropertyVal = 'Chicago')
group by RecordID
having count(distinct PropertyID) = 2
)
Not sure what you want exactly. It's probably either
...
where (PropertyID = 13 AND PropertyVal='Business Development Analyst')
or (PropertyID = 11 AND PropertyVal = 'Chicago')
or
...
where PropertyID in (13, 11)
and PropertyVal in ('Business Development Analyst', 'Chicago')