select *
FROM A
LEFT JOIN B
ON A.ID = B.ID
LEFT JOIN C
ON C.ID = A.ID
LEFT JOIN D
ON D.date = C.date
请问这种multiple join的顺序是怎样的?thank you very much.
L****n 发帖数: 3545
2
(result of A join B) join C, get a table then join D
【在 t********1 的大作中提到】 : select * : FROM A : LEFT JOIN B : ON A.ID = B.ID : LEFT JOIN C : ON C.ID = A.ID : LEFT JOIN D : ON D.date = C.date : 请问这种multiple join的顺序是怎样的?thank you very much.