表A有
F_XM,F_ZB,F_QJ,F_0四个字段。
表B有tbdata,tbxm,tbzb,tbqj
想让update a set F_0= c.hj from (select sum(tbdata),tbxm,tbzb from b where f_xm=tbxm and f_qj=tbqj and f_zb=tbzb group by tbxm,tbzb) where f_qj='***'
上面的是伪代码,求高手
F_XM,F_ZB,F_QJ,F_0四个字段。
表B有tbdata,tbxm,tbzb,tbqj
想让update a set F_0= c.hj from (select sum(tbdata),tbxm,tbzb from b where f_xm=tbxm and f_qj=tbqj and f_zb=tbzb group by tbxm,tbzb) where f_qj='***'
上面的是伪代码,求高手
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货