试试这样:
select a.bh_sq, a.zcmc,a.zcly,a.bh_bgy,B.XH,b.sj_cr,b.sj_wc,b.dm_czy from ea_zcxx a,(select max(xh) from ea_lcb group by bh_sq) b where a.bh_sq=b.bh_sq;
select a.bh_sq, a.zcmc,a.zcly,a.bh_bgy,B.XH,b.sj_cr,b.sj_wc,b.dm_czy from ea_zcxx a,(select max(xh) from ea_lcb group by bh_sq) b where a.bh_sq=b.bh_sq;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货