用ADOCommand执行下列语句,老是提示错误,找不到原因。其中view_elel_ls_cgrk是视图
SELECT * into Table2 from (select * from view_elel_ls_cgrk where sh_date > '2001-01-01'and sh_date <'2013-12-12')
...全文
2833打赏收藏
大家帮我看看ADOCommand执行为何出错?
用ADOCommand执行下列语句,老是提示错误,找不到原因。其中view_elel_ls_cgrk是视图 SELECT * into Table2 from (select * from view_elel_ls_cgrk where sh_date > '2001-01-01'and sh_date <'2013-12-12')
SELECT * into Table2 from (select * from view_elel_ls_cgrk where sh_date > '2001-01-01' and sh_date <'2013-12-12')
上面"and“前没空格,另外子查询在")"后应加一个别名,如:....) a