Who's the Communist ticket with an American Labor ticket of joseph v. o'leary?
CREATE TABLE "1942_state_election_results" (
  "republican_ticket" text,
  "democratic_ticket" text,
  "american_labor_ticket" text,
  "communist_ticket" text,
  "socialist_ticket" text
);
SELECT "communist_ticket" FROM "1942_state_election_results" WHERE "american_labor_ticket"='joseph v. o''leary';