Question

List the invoice number and invoice date for each invoice that was created for James Gonzalez but that does not contain an invoice line for Wild Bird Food (25lb).

Answer 1

Derive FROM invoice_transaction, invoice_details, item_details

and JOIN customer_details ON (invoice_transaction.CUST_ID = customer_details.CUST_ID AND customer_details.FIRST_NAME = 'James' AND customer_details.LAST_NAME = 'Gonzalez')

Step-by-step explanation:

The following details will be there in the invoice

1. item_details
2. rep_details
3. invoice_details
4. customer_details
5. invoice_transaction

Derive FROM invoice_transaction, invoice_details, item_details

and JOIN customer_details ON (invoice_transaction.CUST_ID = customer_details.CUST_ID AND customer_details.FIRST_NAME = 'James' AND customer_details.LAST_NAME = 'Gonzalez')