Joining Tables in a Query - Inner Joins in MS Access - Office 365

You can join tables in queries. You can create joins between tables in three ways. First, by creating relationships between the tables when you design the database. Second, by selecting two tables that have a field in common and the field is a primary key in one of the tables. Third, by creating a join in the query designer. All these joins are inner joins.

[HumFan]

you are hands down the best channel for these tutorials. thank you so much

[zobeidachaffee]

This is a very helpful video. But, is there a way to make a query that does not exclude records? For instance if I have a table customer, and a table order, which have the corresponding customer ID fields, and I want to also show customers who have not ordered anything in the query (so they would not have a record in the order table at all)