update t2 set t2. reserve4= isnull(t1.CAC, '-') + right(rtrim(ltrim('---' + isnull(t1.TRDCHN, '') + isnull(t1.SUBTRDCHN, ''))), 3) --as partner_type
from BASIS_OM01 t1,t1,SDS101_Customer t2,
(select outlet,OUTNUM
from BASIS_OM01 t1 ,SDS101_Customer t2, BA101_CIPARTNER t3,
where t1.OUTNUM+90000000=t2.outlet and t2.teamcode = t1.PTNCODE
and convert(int,SUBSTRING(LTRIM(t1.BASARE030B),1,13))=0 and t1.BUSTYP=1) t3
where t2.outlet=t3.outlet and t1.OUTNUM=t3.OUTNUM AND t1.BUSTYP=0
from BASIS_OM01 t1,t1,SDS101_Customer t2,
(select outlet,OUTNUM
from BASIS_OM01 t1 ,SDS101_Customer t2, BA101_CIPARTNER t3,
where t1.OUTNUM+90000000=t2.outlet and t2.teamcode = t1.PTNCODE
and convert(int,SUBSTRING(LTRIM(t1.BASARE030B),1,13))=0 and t1.BUSTYP=1) t3
where t2.outlet=t3.outlet and t1.OUTNUM=t3.OUTNUM AND t1.BUSTYP=0
set t2.reserve4= isnull(t1.CAC, '-') + right(rtrim(ltrim('---' + isnull(t1.TRDCHN, '') + isnull(t1.SUBTRDCHN, ''))), 3) --as partner_type
from BASIS_OM01 t1,t1,SDS101_Customer t2,
(select outlet,OUTNUM
from BASIS_OM01 t1 ,SDS101_Customer t2, BA101_CIPARTNER t3,
where t1.OUTNUM+90000000=t2.outlet and t2.teamcode = t1.PTNCODE
and convert(int,SUBSTRING(LTRIM(t1.BASARE030B),1,13))=0 and t1.BUSTYP=1) t3
where t2.outlet=t3.outlet and t1.OUTNUM=t3.OUTNUM AND t1.BUSTYP=0
from BASIS_OM01 t1,SDS101_Customer t2,
(select outlet,OUTNUM
from BASIS_OM01 t1 ,SDS101_Customer t2, BA101_CIPARTNER t3,
where t1.OUTNUM+90000000=t2.outlet and t2.teamcode = t1.PTNCODE
and convert(int,SUBSTRING(LTRIM(t1.BASARE030B),1,13))=0 and t1.BUSTYP=1) t3
where t2.outlet=t3.outlet and t1.OUTNUM=t3.OUTNUM AND t1.BUSTYP=0 不好意思,已经更正