Selecting Data Using Queries in Microsoft Access 2013
- 3/15/2013
Contents
×
- Selecting all columns from a table
- Selecting individual columns from one or more tables
- Joining tables to see unmatched or missing records
- Filtering by single and multiple combinations of choices
- Adding calculations with the expression builder
- Returning the top matched records
- Eliminating duplicate values
- Creating a summary calculation
- Prompting to filter data with parameters
- Creating a crosstab query with the Query Wizard
- Simplifying a problem with a query by using other queries
- Adding two sets of query results together
- Resolving ambiguous outer joins
- Creating an additional query to resolve a problem with mixed joins
Resolving ambiguous outer joins
When you join tables together on a query and you have a line without any arrows at either end, you have an equally matched join (sometimes called an INNER JOIN or simply a JOIN). In the earlier parts of this section, we displayed unmatched records and missing parent records by adding an arrow at one end of the join; this is called an OUTER JOIN (being LEFT or RIGHT depending on which end all records are being displayed from). If you add tables to a query where you have already specified OUTER JOINS in the relationships, these will be shown by default when you add the tables to the query grid.
If you have a mixture of join types when you try to run a query, you will be warned that you have a join ambiguity, as shown here.
)