Question: which one of the following is a valid join type?
Answer: ANSI-standard SQL specifies five types of JOIN : INNER , LEFT OUTER , RIGHT OUTER , FULL OUTER and CROSS . As a special case, a table (base table, view, or joined table) can JOIN to itself in a self-Join. A programmer declares a JOIN statement to identify rows for joining.