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

Chris W. Parker cparker at swatgear.com
Mon Oct 21 18:54:01 CDT 2002

> -----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

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.


More information about the thelist mailing list