这个语句到底哪儿错了?
insert tem3 values
(
"a1",
(select sum(sl) from tem2 where dealer="a1"),
(select sum(sl) from tem2 where dealer="a1" and product="b1"),
(select sum(sl) from tem2 where dealer="a1" and product="b2"),
(select sum(sl) from tem2 where dealer="a1" and product="b3")
)
说是insert into 语法错误,哪儿错了?tem3表是已经存在的。
我用的数据库是Access