CREATE TABLE table_14635 ("Team" CLOB, "Manager" CLOB, "Captain" CLOB, "Kit manufacturer" CLOB, "Shirt sponsor" CLOB)

Which captain's manager is Joe Royle?
SELECT "Captain" FROM table_14635 WHERE "Manager" = 'joe royle'
SELECT "Captain" FROM "table_14635" WHERE "Manager" = 'joe royle'