Explain the difference between an inner join and outer join. Why is it important to understand joins when trying to retrieve data for decision making?
What will be an ideal response?
• An inner join is a join that selects only those records from both database tables that have matching values and is the default join setting in Access. One or more fields can serve as the join fields and records with values in the joined field(s) that do not appear in both of the database tables will be excluded from the query dataset.
• An outer join selects ALL of the records from one database table and only those records in the second table that have matching values in the joined field. One or more fields can serve as the join field.
• Joins help you control which records will be displayed in the query dataset. This enables you to enhance your dataset even further to find the data that you want.
You might also like to view...
The ___________________ functions return values indicating an object’s proximity to another object.
Fill in the blank(s) with the appropriate word(s).
Comparable
A) is a class that allows two objects to be compared B) is an interface implemented by classes that need to impose a natural order on instance objects C) is a library class method that is used by certain sorting packages D) None of the above
When dates and times are entered as query criteria they are surrounded by ________
A) [ ] B) ( ) C) " " D) # #
In a binary tree, the branches go only from a child to a parent.
Answer the following statement true (T) or false (F)