CREATE TABLE table_26129220_2 (party VARCHAR2, senator VARCHAR2)

What is the party affiliation for Senator David Goodman?
SELECT party FROM table_26129220_2 WHERE senator = "David Goodman"
SELECT "party" FROM "table_26129220_2" WHERE "David Goodman" = "senator"