Working with joins

…When creating queries that include…multiple tables, it's important to understand…how those tables are related in order to get meaningful results.…Typically, Access will be able to assist you in…building these relationships if they've not been previously defined.…But there are occasions when you'll need to…create or modify how your tables are joined together.…Let's take a look at a couple of examples.…First, I'm going to go to DATABASE TOOLS and take a…look at the Relationships that we have in this database.…We can see that we have relationships between…products, orders, customers, states and our employees here.…

These are indicated by the black lines between each of these tables.…Let's go ahead and delete some of…these joins between customers, states and orders.…I'll click here, and then I'll right click and say delete.…It's going to warn me about my relationships, and I'll just say yes.…Next, I'm going to delete the one between customers and states.…Again, I'll just right click on it and say delete.…Once again, I'll say yes to permanently delete the selected relationship.…