select * from g2,s58 where g2.sCode = s58.sCode and g2.gfp<s58.sfp and s58.sDate=(select max(tem.sDate) from (select g2.dcode,s58.sdate from g2,s58 where g2.sCode = s58.sCode and g2.gfp<s58.sfp) tem where tem.dcode=g2.dcode)
调试欢乐多
select a.dcode,max(b.sDate) as MDate
from g2 a
inner join s58 b on a.scode=b.scode and a.gfp<b.sfp
group by a.dcode