When you join tables, the type of join that you create affects the rows that appear in the result set. You can create the following types of joins: Inner join A join that displays only the rows that have a match in both joined tables. (This is the default type of join in the Query and View Designer .) For example, you can join the titles and publishers tables to create a result set that shows the publisher name for each title. In an inner join, titles for which you do not have publisher information are not included in the result set, nor are publishers with no titles. The resulting SQL for such a join might look like this: SELECT title, pub_name FROM titles INNER JOIN publishers ON titles.pub_id = publishers.pub_id Note Columns containing NULL do not match any values when you are creating an inner join and are therefore excluded from the result set. Null values do not match other null values. O...