拼sql
注:access 2003测试通过
select sum(price) from (
select price from products where id=5
union
select price from products where id=2
union
select price from products where id=3
union
se……
[/Quote]
这个可以啊 …… 不知道效率如何……
拼sql
注:access 2003测试通过
select sum(price) from (
select price from products where id=5
union
select price from products where id=2
union
select price from products where id=3
union
select price from products where id=4
union
select price from products where id=4
...
);