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

[Chris W. Parker]

> -----Original Message-----
> From: Scott Schrantz [mailto:scotts at rci-nv.com]
>
> > -----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.

now this might be hard to believe, but i've yet been able to figure out
how to use access for this purpose. writing the query's by hand has been
much more fruitful than using access.

so if you would, list the steps you took to make that query in access.


chris.