Question

Which of the following is a correctly formatted select statement to show the following result set with the invoice total, customer's customer id, and the invoice's billing state?

SELECT invoice_total, invoice.customer_id, billing_state FROM invoice JOIN customer ON _____
a) invoice.customer_id = customer.customer_id
b) invoice.invoice_id = customer.invoice_id
c) invoice.customer_id = customer.id
d) invoice.id = customer.invoice_id

Answer 1

The correct formatted select statement to show the given result set is: SELECT invoice_total, invoice.customer_id, billing_state FROM invoice JOIN customer ON invoice.customer_id = customer.customer_id.

Step-by-step explanation:

The correct formatted select statement to show the given result set with the invoice total, customer's customer id, and the invoice's billing state is:

SELECT invoice_total, invoice.customer_id, billing_state FROM invoice JOIN customer ON invoice.customer_id = customer.customer_id