写程序

deric79

请问我这程序错在哪里呢？请高手帮忙。

WHERE sub."Corp_ID" = ('XXX1','XXX2','XXX3','XXX4','XXX5','XXX6','XXX7')
ORDER BY "Corp_ID",
          "Client_ID",
          "Client_Account_No",
          "Client_Account_name",
          "User_Corporation",
          "user_client",
          "user_Category",
          "User_id",
          "Bank_Product";

>[Error] Script lines: 1-258 ------------------------
ORA-01797: this operator must be followed by ANY or ALL
Script line 249, statement line 249, column 22 

[Executed: 1/17/2018 11:18:32 AM] [Execution: 0ms]

sm99999

WHERE sub."Corp_ID" in ('XXX1','XXX2','XXX3','XXX4','XXX5','XXX6','XXX7')

http://www.dofactory.com/sql/where-in