A. SELECT is used to join two or more tables.
C. Using =* is equivalent to using the ANSI SQL RIGHT OUTER JOIN.
A, C, and D. No keyword is required for self-joins.