SELECT B.common_col, A.other_col, C.other_col
FROM B
INNER JOIN A ON A.common_col = B.common_col
INNER JOIN C ON B.common_col = C.common_col;
SELECT B.common_col, A.other_col, C.other_col
FROM B
INNER JOIN A ON A.common_col = B.common_col
INNER JOIN C ON B.common_col = C.common_col;