[thelist] SQL: looking for resources, have one question

[Scott Schrantz]

> -----Original Message-----
> From: Chris W. Parker [mailto:cparker at swatgear.com]
>
> 2. are there any good recommendations for websites and/or books that i
> should take a look at that explain in detail (and possibly
> with pictures [i'm a visual kind of guy]) what the hell is happening when
> it comes to JOINs? (or any other more advanced logic in SQL.)

There is a way to cheat and have Access build your JOINs for you. (Don't let
Rudy know!) If you build a Query in Access, it will construct a SQL
statement for you. Just go to View>SQL View, and you can copy and paste from
there. If you draw data from two or more tables, it will build an INNER
JOIN.

Here's what Access gives for your question:

SELECT products.ID, manufacturers.name
 FROM manufacturers
  INNER JOIN products
  ON manufacturers.ID = products.manufacturerID;

--
Scott Schrantz
work: www.rci-nv.com
play: www.computer-vet.com