Linking Tables at the Table Level Vs. the Query Level

[Tammy]

I'm building a database for our Engineering Project Controls. I'm curious how people are linking their tables? Do you link them at the table level or the query level and why? What are the benefits to linking at the tbl level vs. the qry level.



Any insights would be appreciated. I'm getting some strange results (ambiguous outter join) and I wnat to make sure that my linking is done correctly.

Thanks for your insights.

Tammy

[orange]

Some sample code may be helpful to readers.
Please describe WHAT you mean by LINKING.

[Tammy]

Sorry, I mean joining the tables vs. joining them through the query. Is there any benefit to doing it either way?

Tammy

[orange]

In a query you can Join two or more tables. If you have a query and you want to join that query to a table, that's possible too.
A select query acts much like a table from an Access perspective. If you use the query wizard, you will see an option for Tables, Queries or Both.

How about showing some code (query SQL) that is giving you a problem?