Join

[Jess.mic]

If in a query it is only mentioned as join , is it a inner join or a outer join . For eg.

SELECT C*

FROM (schema.customer C JOIN schema.address A ON ((A.CUSTOMER_ID = C.CUSTOMER_ID)))


So is it a inner join or the outer join???

[nnani]

Hello Jess,

The query given by you

Code: Select all

SELECT C* 
FROM (schema.customer C JOIN schema.address A ON ((A.CUSTOMER_ID = C.CUSTOMER_ID)))

This query is representing a inner join.
Even if you omit the word [INNER] and just mention join, Vertica assumes it to be an inner join.

Hope this solved your confusion