select
t1.总买入金额
from
(select o.info_type_code,
o.main_id
from UPCENTER.STK_EXCRA_INFO_MAIn o
where o.info_type_code in(1,2,3,5,6,12,13,14,15,16,17,22,23,28,29,30,31,32,33)
) t
//取买入金额
left join(select buy_amount 总买入金额 from (select distinct sub_id,branch_code,branch_name,buy_amount from UPCENTER.STK_EXCRA_BRANCH_LIST where isvalid=1 )) t1 on t.main_id=t1.SUB_ID这语句哪里有问题啊
t1.总买入金额
from
(select o.info_type_code,
o.main_id
from UPCENTER.STK_EXCRA_INFO_MAIn o
where o.info_type_code in(1,2,3,5,6,12,13,14,15,16,17,22,23,28,29,30,31,32,33)
) t
//取买入金额
left join(select buy_amount 总买入金额 from (select distinct sub_id,branch_code,branch_name,buy_amount from UPCENTER.STK_EXCRA_BRANCH_LIST where isvalid=1 )) t1 on t.main_id=t1.SUB_ID这语句哪里有问题啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货