您所在位置：主题：怎么实现union all联接的语句？？？？
booksword
[专家分：210] 发布于 2006-09-01 23:09:00
我写了
select crkbj,dwmc,sum(jhsl)
from ypjc where bm='010140'
group by crkbj,dwmc
union all
select crkbj,dwmc,sum(jhsl)
from sfypjc where bm='010140'
group by crkbj,dwmc
这可写在SQL中能实现我要的效果，
但不知道怎么在程序实现
我用的bm 是用adodataset1.parmerters通过变量引入
但会报错帮忙写个例子谢了先，
select crkbj,dwmc,sum(jhsl)
from ypjc where bm='010140'
group by crkbj,dwmc
union all
select crkbj,dwmc,sum(jhsl)
from sfypjc where bm='010140'
group by crkbj,dwmc
这可写在SQL中能实现我要的效果，
但不知道怎么在程序实现
我用的bm 是用adodataset1.parmerters通过变量引入
但会报错帮忙写个例子谢了先，
