SELECt a.id, a.sales, a.date, (SELECT TOP 1 Goal FROM TableB b WHERe b.date < a.date ORDER BY b.date DESC) As GoalFROM TableA a
过去的最近日期。
SELECt a.id, a.sales, a.date, (SELECT TOP 1 Goal FROM TableB b WHERe b.date < a.date ORDER BY b.date DESC) As GoalFROM TableA a
过去的最近日期。
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
