The Art of SQL

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