Select rows to display the columns: name of product/service assign alias as “ProductService”, quantity sold of
product (invoice detail), employeeID who is assigned to the invoice; where the employee ID equals 1; sort by
name of product/service ascending.
24 freelancers are bidding on average $19 for this job
Here's your query. SELECT [login to view URL] AS ProductService, [login to view URL], [login to view URL] FROM InvoiceDetail B INNER JOIN ProductsAndServices A ON [login to view URL] = [login to view URL] INNER JOIN Invoice C ON [login to view URL] = [login to view URL] WHERE [login to view URL] = 1 ORD More
I am a 4 year experienced Senior Software Engineer. I have done similar SQL queries in variety of projects ranging from web applications to mobile apps. I will complete the job for you in one day.