CREATE TABLE table_41709 ("Team 1" CLOB, "Agg." CLOB, "Team 2" CLOB, "1st leg" CLOB, "2nd leg" CLOB)

Which Team 2 had a Team 1of joe public?
SELECT "Team 2" FROM table_41709 WHERE "Team 1" = 'joe public'
SELECT "Team 2" FROM "table_41709" WHERE "Team 1" = 'joe public'