[thelist] SQL: looking for resources, have one question
Chris W. Parker
cparker at swatgear.com
Tue Oct 22 11:28:01 CDT 2002
> -----Original Message-----
> From: Scott Schrantz [mailto:scotts at rci-nv.com]
>
> Assuming you've already set up your tables (Access 2000):
>
> * Go to Queries
> * Choose "Create Query in Design view"
> * A list of your tables will pop up. Add products and
> manufacturers, then
> close the pop-up.
> * Drag the ID from the products table down to the first
> column, and name
> from the manufacturers table down to the second column.
> * You've written your query! Go to View>SQL View.
> * If you play around with the Sort and Criteria fields, it
> will add ORDER BY
> and WHERE clauses for you too.
hey look at that! it worked like a charm!
the reason i'd never been able to do it right was because i was going at
it all wrong! that was easy.
!!!
chris.
More information about the thelist
mailing list