Access SQL插入语句 insert into 批量多条

农经权

Insert into CBF_JTCY ([CBFBM],[CYXM],[CYXB],[CYZJLX],[CYZJHM],[YHZGX],[CYBZ],[SFGYR],[CYBZSM]) Select [CBFBM],[CYXM],[CYXB],[CYZJLX],[CYZJHM],[YHZGX],[CYBZ],[SFGYR],[CYBZSM] from CBF_JTCY_Ex where [Action] = "Create"

Other

Insert into 进货 ([商品ID],[进价],[数量],[日期],[结存进货],[结存ID]) Select [商品ID],[进货成本] as 进价,[进货数量] as 数量, %f as 日期,true as 结存进货,%d from 结存单 where [结存ID] = %0:d and [剩余库存] > 0