CREATE TABLE table_name_49 (captain VARCHAR(255), manager VARCHAR(255))
Which captain's manager is Joe Royle?
    
SQL: SELECT captain FROM table_name_49 WHERE manager = "joe royle"