SQL语句，高手进

[zdleek]

SQL Server
有表如下

表1：g2
主要字段：
sCode varchar (8)
dCode varchar (8)
gfp numeric(18,4)
f001 numeric(18,4)
f002 numeric(18,4)

表2：s58
主要字段：
sCode varchar (8)
sfp numeric(18,4)
sDate smalldate

要求：根据dCode分组，取出sDate（时间）最近的记录,
并且g2.gfp < s58.sfp AND g2.sCode = s58.sCode

[pengdali]

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)

[yczzg]

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

[zdleek]

问题解决，结贴