34,838
社区成员




一:
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<=[终止日期]