--得到有效卡片
SELECT sCardID FROM fa_Cards
WHERE fa_Cards.sCardID IN(SELECT Max(sCardID) FROM fa_Cards
WHERE (((fa_Cards.dInputDate)<=@LoginDate) AND ((fa_Cards.dTransDate)<=@LoginDate Or (fa_Cards.dTransDate) Is Null) AND ((fa_Cards.dDisposeDate)<=@LoginDate Or (fa_Cards.dDisposeDate) Is Null))
GROUP BY fa_Cards.sCardNum)
SELECT sCardID FROM fa_Cards
WHERE fa_Cards.sCardID IN(SELECT Max(sCardID) FROM fa_Cards
WHERE (((fa_Cards.dInputDate)<=@LoginDate) AND ((fa_Cards.dTransDate)<=@LoginDate Or (fa_Cards.dTransDate) Is Null) AND ((fa_Cards.dDisposeDate)<=@LoginDate Or (fa_Cards.dDisposeDate) Is Null))
GROUP BY fa_Cards.sCardNum)
扫一扫
1577
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
