force_outer with multiple join

edited November 2017 in General Discussion

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?

Comments

  • Jim_KnicelyJim_Knicely Administrator

    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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file