Is it possible to chain a join to an outer joined table?
I have three tables, A, B, and C
Table A parent records have optional child records in table B.
So I did an outer join and it works fine.
But I want to expand a column of the child table B.
Parent Table A ---> left outer joined to optional child table B ----> lookup a column of B in table C
Can that be done ?