UPDATE t_billingtable_his_tmp a
SET (a.FCHANNELID,a.fchannelname)=
(SELECT DISTINCT FCHANNELID,FCHANNElname FROM [email protected] b WHERE b.fmsgtype=60 AND a.FLINKID=b.FLINKID)
WHERE a.fmsgtype=62 and a.fchannelid=0
AND a.partid='0801' t_billingtable_his_tmp 上有一个 index partid
SET (a.FCHANNELID,a.fchannelname)=
(SELECT DISTINCT FCHANNELID,FCHANNElname FROM [email protected] b WHERE b.fmsgtype=60 AND a.FLINKID=b.FLINKID)
WHERE a.fmsgtype=62 and a.fchannelid=0
AND a.partid='0801' t_billingtable_his_tmp 上有一个 index partid
FCHANNELID,FCHANNElname 建联合索引
msgtype ,FLINKID 分别建索引
另外,疑问是这样的语句也能通过编译 ???