Why do we use query to make relationship?

[longmatch]

From Access database, I know we can even use query to establish relationship. what is the advantage to use query, instead of table, as component of relationship?

Haijun

 

[WildHare]

The difference is that with a query, you can build your join in "either" direction, and use Inner and Outer Left and Right joins - whereas if you join two (or more) tables directly, you must set the type explicitly as just ONE variety.

They both have their justifications - it depends on what kind of data you want to get.

I usually join at the table level only for Lookup tables that I want to establish referential integrity for on the "many" side.



Remember, you're unique - just like everyone else
You're invited to visit another free Access forum:

http://www.forumco.com/jmhare

or my site,

http://www.jmhare.com