Task 11: Display only customers that have orders or payments
The database contains customers that do not have orders or payments. The query for the customers report returns all customers. When you run the report, there are customer rows that show only the column headings for the Orders and Payments tables, as shown in Figure 12-23.
The WHERE EXISTS clause checks the Orders and Payments tables for customerNumber values that match the customerNumber values in the Customers table. Only rows that have matching customerNumber values are selected. The complete query should look like the one shown in Figure 12-24.Figure 12-24 Updated SELECT query in Edit Data Set
(c) Copyright Actuate Corporation 2013 |