| [SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z] joins anti-joins conditions conditions (WHERE clause) 2nd cross equi-joins 2nd hierachical query usage inner 2nd syntax key-preserved tables mimicking analytic queries with natural new syntax non-equi-joins 2nd self outer 2nd full left LEFT/RIGHT right self syntax placement of queries self 2nd semi-joins stored functions, avoiding subqueries types of vertical views, DML statements on |