How to group joins in OpenSQL

Question

I'd like to do the equivalent of

 SELECT * FROM A LEFT OUTER JOIN (B INNER JOIN C)

using OpenSQL. Is this possible and what is the syntax?

Answer 1

It is possible, but the grouping needs to be an inline view in its own right. So, adapting your example here.

SELECT *
FROM A
    LEFT OUTER JOIN (
        SELECT B.FirstColumn, C.SecondColumn, B.Thirdcolumn
        FROM B
            INNER JOIN C
        ) D ON A.Something = D.SomethingElse

No outer references - The inline view cannot reference columns from table A unless it is part of the inline-query in its own right.

Any more specifics would likely need more detail about your query and intent.