求助！！！创建视图时出错。。。。。。

[wlz1949]

创建视图的mysql语句：
CREATE
/*[ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
[DEFINER = { user | CURRENT_USER }]
[SQL SECURITY { DEFINER | INVOKER }]*/
VIEW `rblp`.`v_case_sign`
AS
(SELECT * ,COUNT(DISTINCT case_id)FROM t_case_sign (WHERE deal_flag = '03' OR deal_flag = '04' OR deal_flag = '05' OR deal_flag = '00' OR return_deal_flag = '00' OR return_deal_flag = '05') GROUP BY case_id );

出现的错误提示：
错误码: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(where deal_flag = '03' or deal_flag = '04' or deal_flag = '05' OR deal_flag = '' at line 7

Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000

求助各位大侠，这个该怎么解决啊。。。。。。

[wlz1949]

感谢你的回答，问题已经解决，与逗号没什么关系，去掉那几个无用的括号再执行就成功了。给你分。

[LMAOhuaNL]

把查询语句里面的‘号统统去掉