SELECT member_name FROM member WHERE party_id  =  3 INTERSECT SELECT member_name FROM member WHERE party_id  =  1
Which member names are shared among members in the party with the id 3 and the party with the id 1?
SELECT member_name FROM member WHERE party_id = 3 INTERSECT SELECT member_name FROM member WHERE party_id = 1
select member_name from member where party_id = value intersect select member_name from member where party_id = value
Which member names are shared among members in the party with the id 3 and the party with the id 1 ?