mysql报错1064怎么办_mysql报错1064怎么办啊

selectitem1,item2,item3,a.run_name,item5,item6,item7,item8,item9from`TD_OA`.`flow_run`a,`TD_OA`.`flow_run_prcs`b,(selectrun_id,item_dataasitem1from`TD_OA`.`flow_run_data`...

select item1,item2,item3,a.run_name,item5,item6,item7,item8,item9

from `TD_OA`.`flow_run` a,

`TD_OA`.`flow_run_prcs` b,

(select run_id,item_data as item1 from `TD_OA`.`flow_run_data` where item_id=1 ;) c,

(select run_id,item_data as item2 from `TD_OA`.`flow_run_data` where item_id=2 ;) d,

(select run_id,item_data as item3 from `TD_OA`.`flow_run_data` where item_id=5 ;) e,

(select run_id,item_data as item5 from `TD_OA`.`flow_run_data` where item_id=10 ;) f,

(select run_id,item_data as item6 from `TD_OA`.`flow_run_data` where item_id=11 ;) g,

(select run_id,item_data as item7 from `TD_OA`.`flow_run_data` where item_id=16 ;) h,

(select run_id,item_data as item8 from `TD_OA`.`flow_run_data` where item_id=20 ;) i,

(select run_id,item_data as item9 from `TD_OA`.`flow_run_data` where item_id=12 ;) j

where a.run_id=b.run_id

and a.run_id=c.run_id

and a.run_id=d.run_id

and a.run_id=e.run_id

and a.run_id=f.run_id

and a.run_id=g.run_id

and a.run_id=h.run_id

and a.run_id=i.run_id

and a.run_id=j.run_id

and b.prcs_id=3

and a.run_id='16293';

错误代码 : 1064

You have an error in your SQL syntax near ') j where a.run_id=b.run_id and a.run_id=c.run_idv and a.run_id=d.run_idv and a.' at line 1

(0 ms用时)

展开