存储过程

Question

有三个查询语句，三个结果的字段是一个意思，想合成起来，
--查询应付余额账款
select --gl_accvouch 凭证及明细账
gl_accvouch.iperiod,--会计期间
gl_accvouch.dbill_date,--制单日期 
purbillvouch.cPBVCode,--PurBillVouch 采购发票主表 cPBVCode 采购发票号   
gl_accvouch.ino_id,--凭证编号 
gl_accvouch.cbill,--制单人 
gl_accvouch.cdigest,--摘要 
Vendor.cVenAbbName, --供应商简称  
Vendor.cVenCode,--供应商编码
code.ccode_name,--会计科目档案 科目名称 
PurBillVouch.cexch_name,--币种名称   
PurBillVouch.cExchRate,--汇率 
PurBillVouch.dGatheringDate ,--到期日 
sum(PurBillVouchs.iOriMoney) as iOriMoney,  --采购发票子表  原币金额 
sum(PurBillVouchs.iOriTotal) as iOriTotal,--累计原币付款 
sum(PurBillVouchs.iOriMoney-PurBillVouchs.iOriTotal) as ybya,  
sum(PurBillVouchs.iMoney) as iMoney,--本币金额 
sum(PurBillVouchs.iTotal) as iTotal,--累计本币付款 
sum(PurBillVouchs.iMoney-PurBillVouchs.iTotal) as bbya,  
code.ccode,--科目编码 
gl_accvouch.coutsysname --外部凭证系统名称 
from PurBillvouch  
left join PurBillVouchs ON PurBillVouch.PBVID = PurBillVouchs.PBVID   
left join gl_accvouch ON PurBillVouchs.cClue=gl_accvouch.coutno_id   --gl_accvouch.coutno_id  外部凭证编号 PurBillVouchs.cClue凭证线索号 
LEFT JOIN Vendor ON PurBillVouch.cUnitCode = Vendor.cVenCode --cUnitCode--供应商编码   
left join code on gl_accvouch.ccode=code.ccode  
where (gl_accvouch.coutsysname='AP' or gl_accvouch.coutsysname='IA')   
and gl_accvouch.ino_id is not null and code.ccode like '2121%' --2121是应付账款
and (PurBillVouchs.iMoney-isnull(PurBillVouchs.iTotal,0))>0  
group by gl_accvouch.iperiod,gl_accvouch.dbill_date,gl_accvouch.ino_id,
gl_accvouch.cbill,  gl_accvouch.cdigest,Vendor.cVenAbbName,Vendor.cVenCode,
code.ccode_name,PurBillVouch.cexch_name,  PurBillVouch.cExchRate,code.ccode,
gl_accvouch.coutsysname,PurBillVouch.dGatheringDate,purbillvouch.cPBVCode   
--Ap_Vouch应付应收单主表 单据日期       单据编号         录入人                 摘要              供应商简称
select null,Ap_Vouch.dVouchDate,ap_vouch.cVouchID,null,Ap_Vouch.cOperator,Ap_Vouch.cDigest,Vendor.cVenAbbName,
Ap_Vouch.cDwCode,code.ccode_name,ap_vouch.cexch_name,ap_vouch.iExchRate,ap_vouch.dGatheringDate,--供应商编码
ap_vouch.iAmount_f,(ap_vouch.iAmount_f-ap_vouch.iRAmount_f) as ybfk,ap_vouch.iRAmount_f,
ap_vouch.iAmount,(ap_vouch.iAmount-ap_vouch.iRAmount) as bbkf,ap_vouch.iRAmount,
code.ccode,ap_vouch.cVouchType
from Ap_Vouch 
left join Ap_Vouchs on Ap_Vouch.Auto_ID=Ap_Vouchs.Auto_ID
left join Vendor on Ap_Vouch.cDwCode=Vendor.cVenCode
left join code on Ap_Vouch.ccode=code.ccode
where Ap_Vouch.cVouchType='P0' and bStartFlag='1' and Ap_Vouch.ccode like '2121%'
and Ap_Vouch.iRAmount_f>0select null,purbillvouch.dPBVDate,purbillvouch.cPBVCode,null,purbillvouch.cPBVVerifier,purbillvouch.cpbvmemo,
Vendor.cVenAbbName,Vendor.cVenCode,code.ccode_name,purbillvouch.cexch_name,purbillvouch.cExchRate,
purbillvouch.dGatheringDate,sum(PurBillVouchs.iOriMoney) as iOriMoney,  
sum(PurBillVouchs.iOriTotal) as iOriTotal,
sum(PurBillVouchs.iOriMoney-PurBillVouchs.iOriTotal) as ybya,  
sum(PurBillVouchs.iMoney) as iMoney,
sum(PurBillVouchs.iTotal) as iTotal,  
sum(PurBillVouchs.iMoney-PurBillVouchs.iTotal) as bbya,  
code.ccode,purbillvouch.cBusType
from PurBillVouch 
left join PurBillVouchs on PurBillVouch.PBVID=PurBillVouchs.PBVID
LEFT JOIN Vendor ON PurBillVouch.cUnitCode = Vendor.cVenCode 
left join code on purbillvouchs.cDebitHead=code.ccode
where PurBillVouch.bFirst='1' and PurBillVouchs.cDebitHead like '2121%' 
and (PurBillVouchs.iMoney-isnull(PurBillVouchs.iTotal,0))>0  
group by purbillvouch.dPBVDate,purbillvouch.cPBVCode,purbillvouch.cPBVVerifier,purbillvouch.cpbvmemo,
Vendor.cVenAbbName,Vendor.cVenCode,code.ccode_name,purbillvouch.cexch_name,purbillvouch.cExchRate,
purbillvouch.dGatheringDate,code.ccode,purbillvouch.cBusType

Answer 1

怎么个合法?
竖着合?用union all
横着合?用子查询.select t1.* , t2.* , t3.*,某些字段的加减
from (...) t1 , (...) t2,(...) t3
where 条件

Answer 2

如果是这么简单，我就不会发帖了。gl_accvouch 是凭证和明细账。Ap_Vouch是应付应收期初表。purbillvouch是采购发票表。第一个结果是取出应付未付的明细账，第二个是应付期初余额，第三个是采购发票的期初余额。现在要把结果整到一个临时表里面，在一个存储过程里面

Answer 3

如果是这样的话,则:最好给出完整的表结构,测试数据,计算方法和正确结果.否则耽搁的是你宝贵的时间。
如果有多表,表之间如何关联?
发帖注意事项
http://topic.csdn.net/u/20091130/21/fb718680-98ff-4afb-98d8-cff2f8293ed5.html?24281