Question: please provide answer in MYSQL workbench: Write a select statement that joins the invoice table to the invoice_line table and returns these columns: InvoiceId, InvoiceDate,
please provide answer in MYSQL workbench:
Write a select statement that joins the invoice table to the invoice_line table and returns these columns: InvoiceId, InvoiceDate, CustomerId, Quantity, and UnitPrice. The query should only return orders for customers 16, 34, 37.
I wrote:
SELECT invoice.invoiceId, invoiceline.invoiceId, invoiceDate, customerId, Quantity, unitPrice FROM invoice JOIN invoiceline WHERE CustomerId = '16 34 37';
but just show me customerId 16
it means I need show me 16, 34, 37
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
