您不能将from
JOIN子句引用到JOIN的另一部分。
改用它。
SELECt * FROM TableA aINNER JOIN TableB b ON b.B1=a.A1INNER JOIN TableC c ON d.C2=b.B2 AND c.C1=b.B1
已编辑
SELECt * FROM TableA aINNER JOIN TableB b ON b.B1=a.A1WHERe b.B2 = (SELECt TOP 1 c.C2 FROM TableC c WHERe c.C1=b.B1 ORDER BY c.C1)
要
TableC在JOIN-s中进一步使用，可以使用它。
SELECt * FROM TableA a INNER JOIN TableB b ON b.B1=a.A1 INNER JOIN (SELECt ROW_NUMBER() OVER (PARTITION BY C1 ORDER BY C2) RN, C2 --, other columns fromTableC if neededFROM TableC ) CC ON b.B2 = CC.C2 AND CC.RN = 1
