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这语句哪里有问题啊