34,590
社区成员
发帖
与我相关
我的任务
分享
一:
SELECT a.f1, a.f2, a.f3, b.f1, b.f2 FROM a INNER JOIN b ON a.ID = b.aID
WHERE a.CreateDate>=[起始日期] AND a.CreateDate<=[终止日期]
二:
SELECT * FROM (SELECT a.CreateDate, a.f1, a.f2, a.f3, b.f1, b.f2 FROM a INNER JOIN b ON a.ID = b.aID) AS T
WHERE T.CreateDate>=[起始日期] AND T.CreateDate<=[终止日期]