%%%%%一个查询问题II%%%%%

nik_Amis 2008-06-07 12:15:38

SELECT a.ID, a.UID,a.FSupplyID, a.FBillNo, a.FItemIDName, a.FCancellation, a.FDate, b.DisplayName, c.FMemo, c.FDate AS FDDate, a.FSendDate
FROM dbo.TB_Order a LEFT JOIN
dbo.TB_User b ON a.FSupplyID = b.SID LEFT JOIN
dbo.TB_Feedback c ON a.FItemIDName = c.FItemIDName AND
a.FBillNo = c.FBillNo AND c.FDate=
(SELECT MAX(FDATE)
FROM TB_Feedback
WHERE a.FItemIDName = c.FItemIDName AND a.FBillNo = c.FBillNo)
我实际的语句是这样的，但是取到的纪录中除了c里面纪录日期最新的一条，其他c.FMemo,FDDate都是null,
而不是根据a.FItemIDName = c.FItemIDName AND a.FBillNo = c.FBillNo分组后，每组的日期最新的纪录

http://topic.csdn.net/u/20080518/23/38430880-5a60-464c-9bc3-2e16b56bcfee.html

...全文

112 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

nik_Amis 2008-06-07

打赏
举报

是啊，最近老忙了hehe

pt1314917 2008-06-07

打赏
举报

可以就结帖吧```
楼主另外一个帖很久没结了。呵呵```

nik_Amis 2008-06-07

打赏
举报

OK，thanks again
that's just what i need

nik_Amis 2008-06-07

打赏
举报

3ks 貌似可以了，我再试一下

懒牛科技 2008-06-07

打赏
举报

太强了.学习了

pt1314917 2008-06-07

打赏
举报



--try:



SELECT a.ID, a.UID,a.FSupplyID, a.FBillNo, a.FItemIDName, a.FCancellation, a.FDate, b.DisplayName, c.FMemo, c.FDate AS FDDate, a.FSendDate 

FROM dbo.TB_Order a LEFT  JOIN 

      dbo.TB_User b ON a.FSupplyID = b.SID 

LEFT  JOIN 

(select * from TB_Feedback t where not exists(select 1 from TB_Feedback where FItemIDName = t.FItemIDName AND FBillNo = t.FBillNo and FDate>t.FDate))c     

ON a.FItemIDName = c.FItemIDName AND 

a.FBillNo = c.FBillNo