CREATE TABLE table_name_49 (captain VARCHAR, manager VARCHAR)

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