CREATE TABLE table_40917 ("Title" TEXT, "Director" TEXT, "Producer" TEXT, "Production Cost" TEXT, "Singapore Gross" TEXT)

Who was the producer for the film directed by 1997?
SELECT "Producer" FROM table_40917 WHERE "Director" = '1997'
SELECT "Producer" FROM "table_40917" WHERE "Director" = '1997'