And select the sql view option from the drop-down list
|
75 |
|---|
• Right Outer Join An outer join for which all the rows are returned from the right-hand table in the join, and data from any matching rows found in the left-hand table is also returned.
• Full Outer Join An outer join for which all rows are returned from both tables, regardless of whether matching data is found between them. Microsoft Access does not currently support this type of join.
|
|
|---|
The completed panel and query results are shown in Figure 3-19.
Comparing the query results in Figure 3-19 with the query results in Figure 3-17, note that there is one more row in Figure 3-19. This is customer FISSA, the one who has no orders in the Orders table. For this row, the Order Date, Shipped Date, and Freight columns are null.
