16 Create Query Produce Total Purchase Per Invoice Generating Results Shown Figure P716 So Q37091701

16. Create a query to produce the total purchase perinvoice, generating the results shown in Figure P7.16, sorted byinvoice number. The invoice total is the sum of the productpurchases in the LINE that corresponds to the INVOICE

FIGURE P7.9 THE CH07 SALECO DATABASE Relational diagram CUSTOMER VENDOR INVOICE PK,FK1 FK1 Cus Code

OR

 

OR