List the invoice number and invoice date for each invoice that was created for James Gonzalez but that does not contain an invoi

Question

koban [17]

2 years ago

10

List the invoice number and invoice date for each invoice that was created for James Gonzalez but that does not contain an invoi

ce line for Wild Bird Food (25lb).

Computers and Technology

1 answer:

Ludmilka [50] · Answer 1 · 2022-07-29T13:44:40+03:00

Answer:

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')

Explanation:

The following details will be there in the invoice

item_details
rep_details
invoice_details
customer_details
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')