[thelist] MS Table Join Question (from Excel)

[r937]

> Didn't know about that "on" splifflety goodness.

it's standard sql (comma style joins with the join conditions in the WHERE 
clause are deprecated)

  SELECT stuff
    FROM table_1 AS al1
  INNER
    JOIN table_2 AS al2
      ON al2.sku = al1.part
  INNER
    JOIN table_3 AS al3
      ON al3.code = al1.code
  LEFT OUTER
    JOIN customer AS al4
      ON al4.customer_number = al1.customer_number
   WHERE other_conditions

couple tips:

- don't ( use ( parentheses )) needlessly

- put your inner joins ahead of the outer joins


--
rudy
http://r937.com/