Table: election_1942
Columns: republican_ticket
democratic_ticket
american_labor_ticket
communist_ticket
socialist_ticket

Question: Who's the Republican ticket with a Communist ticket of elizabeth gurley flynn?
SQL: SELECT "republican_ticket" FROM election_1942 WHERE "communist_ticket" = 'elizabeth gurley flynn'

Question: Who's the Communist ticket with an American Labor ticket of joseph v. o'leary?
SQL: SELECT "communist_ticket" FROM election_1942 WHERE "american_labor_ticket" = 'joseph v. o''leary'

Question: Who's the Republican ticket with a Democratic ticket of flora d. johnson?
SQL: SELECT "republican_ticket" FROM election_1942 WHERE "democratic_ticket" = 'flora d. johnson'

Question: Who's the Republican ticket with a Communist ticket of (none), and a Socialist ticket of joseph g. glass?
SQL: SELECT "republican_ticket" FROM election_1942 WHERE "communist_ticket" = '(none)' AND "socialist_ticket" = 'joseph g. glass'

Question: Who's the Republican ticket with a Democratic ticket of matthew j. merritt?
SQL: SELECT "republican_ticket" FROM election_1942 WHERE "democratic_ticket" = 'matthew j. merritt'