When using SAS Data Integration Studio's SQL Join transformation, which SQL join type can be constructed as either an implicit or an explicit join?

Question

Options

• AUnion
• BFull
• CInner
• DCross

• A
  4% (1)
• B
  7% (2)
• C
  85% (23)
• D
  4% (1)

Explanation

Inner Join is correct because it is the only join type in SAS Data Integration Studio's SQL Join transformation that supports both an implicit form (comma-separated tables in the FROM clause with the condition in a WHERE clause: FROM a, b WHERE a.id = b.id) and an explicit form (using INNER JOIN ... ON syntax). The other join types-Full Outer, Left Outer, Right Outer-require explicit JOIN syntax and have no implicit equivalent in standard SQL. Union (A) is a set operation that stacks rows vertically, not a join type at all. Full (B) can only be expressed as an explicit FULL OUTER JOIN. Cross (D) is a Cartesian product and, within SAS DI Studio's transformation options, is configured only as an explicit join type.

Memory tip: "Inner goes either way" - the Inner join is the flexible one, supporting both old-school implicit (comma + WHERE) and modern explicit (JOIN...ON) syntax, while all other real join types demand the explicit form.

No community discussion yet for this question.