CREATE TABLE table_name_26 (opponent VARCHAR2, loss VARCHAR2)

Who lost to moyer (9 4)?
SELECT opponent FROM table_name_26 WHERE loss = "moyer (9–4)"
SELECT "opponent" FROM "table_name_26" WHERE "loss" = "moyer (9–4)"