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



More information about the thelist mailing list