try:
Select * from jc_dw a
join cz_jg b on a.dw_bm = b.cz_jg
join
(Select dw_bm,max(报送时间) as 报送时间 from cz_jg group by dw_bm) c
on b.dw_bm = c.dw_bm and b.报送时间 = c.报送时间
Select * from jc_dw a
join cz_jg b on a.dw_bm = b.cz_jg
join
(Select dw_bm,max(报送时间) as 报送时间 from cz_jg group by dw_bm) c
on b.dw_bm = c.dw_bm and b.报送时间 = c.报送时间
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货