Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started