force_outer with multiple join

ijevsk

According to the vertica documentation force_outer can determine the inner and aouter table what happen if i have more than one join. for example I have "..from a join b join c...."
join a and b will be derermined according to the force_outer of a and b, but that about ( a and b ) and c ? what will be inner and what outer table?

Jim_Knicely

A column in table c will have to join with a column in either table a or b. So the FORCE OUTER value of table c will be compared to which ever table (a or b) it joins to determine if c should be the inner or outer table.

I attached a simple example that I hope shows this.