CREATE TABLE table_26593762_2 (team VARCHAR2, manager VARCHAR2)

Who is the captain of Dave Jones' team?
SELECT team AS captain FROM table_26593762_2 WHERE manager = "Dave Jones"
SELECT "team" AS "captain" FROM "table_26593762_2" WHERE "Dave Jones" = "manager"