J
jlyin
Unregistered / Unconfirmed
GUEST, unregistred user!
TO YSAI
sql explorer调试通不过，如下，库名换成issucard,只取一个表都不行；
select I.MeterNo,I.BranchNo
,I.NowPay,I.Ullage_Amt,I.Paydate
from Issucard I
where I.Flag<2
and I.meterno in
(select MeterNo From
( select MeterNo,max(paydate)
from Issucard
group by MeterNo)
)
to,zqflying:
不能这样用TMP
至少PARADOX库不行，
至于另外的方法，DATADIFF()没试
sql explorer调试通不过，如下，库名换成issucard,只取一个表都不行；
select I.MeterNo,I.BranchNo
,I.NowPay,I.Ullage_Amt,I.Paydate
from Issucard I
where I.Flag<2
and I.meterno in
(select MeterNo From
( select MeterNo,max(paydate)
from Issucard
group by MeterNo)
)
to,zqflying:
不能这样用TMP
至少PARADOX库不行，
至于另外的方法，DATADIFF()没试