sql two tables relationship

[tamethetikbalang]

how do you query two tables in access that are in a relationship?

 

[Tarwn]

http://www.w3schools.com/sql/sql_intro.asp

W3Schools ought to have you covered there. Doing a SELECT from two tables is a relatively basic task, which is why I am not providing a direct answer. If you read far enough through the SQL erference I provided you should get a better overal understanding of what your doing plus be able to do it in your own the next time you need it. SQL is a fairly simple language once you get used to it, having only a small number of possible words and some very strict rules as to what ordertey can appear in. It's not until you get to Stored Procudes and such that it really begins to approach the complexity of a programming language.

-T