摘要:
dbo.T_CUSTOM_SIGNBILL AS Z ON dbo.T_STAFF_BASIC.SID = Z.SID AND Z.FWH1 = (SELECT TOP (1) FWH1 FROM dbo.T_CUSTOM_SIGNBILL ORDER BY UPYMD DESC)这段代码写了后,里面的字段为NULL 这个表里面因为有很多重复的字段,要把最新的数据显示出来应该改为(select t.sid,t.gongzi,'' as FWH3 from T_CUSTOM_SIGNBILL T,(SELECT sid, max (UPYMD) FWH3 FROM dbo.T_C 阅读全文