我在vb中用到以下一条sql语句,但每次执行都报错,谁能帮我解决这个问题,必给高分
insert into table1(name,id,type) select name as 'name',id as 'id',type as 'type' from table2 where T1date>=date1 and T1date<=date2
...全文
276打赏收藏
急!!!在线等待
我在vb中用到以下一条sql语句,但每次执行都报错,谁能帮我解决这个问题,必给高分 insert into table1(name,id,type) select name as 'name',id as 'id',type as 'type' from table2 where T1date>=date1 and T1date<=date2
insert into table1(name,id,type) values(select name as 'name',id as 'id',type as 'type' from table2 where T1date>=date1 and T1date<=date2)
如果是access则:
insert into table1(name,id,type) values(select name as 'name',id as 'id',type as 'type' from table2 where datediff("d",T1date,date1)<=0 and datediff("d",T1date,date2)>=0