CREATE TABLE Member (member_name VARCHAR2, party_id VARCHAR2)
CREATE TABLE party (party_id VARCHAR2, Party_name VARCHAR2)

Show member names that are not in the Progress Party.
SELECT T1.member_name FROM Member AS T1 JOIN party AS T2 ON T1.party_id = T2.party_id WHERE T2.Party_name <> "Progress Party"
SELECT "T1"."member_name" FROM "Member" "T1" JOIN "party" "T2" ON "Progress Party" <> "T2"."Party_name" AND "T1"."party_id" = "T2"."party_id"