Microsoft Access 2010 Bible

Chapter 13: Accessing Data with VBA Code

483

FIGURE 13.5

A query using a LEFT JOIN clause

Notice that InvoiceNumber is not included in the SELECT clause. In this example, there is no

reason to include the InvoiceNumber as part of the SELECT clause because it will be blank

(Null) in every record returned by the query. (This query’s results are shown in Figure 13.6.)

However, InvoiceNumber is included in the WHERE clause, of course. The WHERE clause could

also include a criteria limiting the results to customers who haven’t placed an order in the last few

months, instead of returning all customers who haven’t ever placed an order. The WHERE clause is

discussed in detail in the next section.

FIGURE 13.6

All customers who have not yet placed an order