Index[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] joins Cartesian 2nd delaying till query end filtering conditions 2nd of two remote tables older join syntax overlooked join condition, hidden by distinct pattern of, deciding factor performance and pre-joining tables problems with regular join with a distinct rewriting uncorrelated subqueries as joins in inline views self-joins on one table unions of complex joins |