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?
force_outer with multiple join
+2A 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.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
