Completed

write and simple SQL query for me

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.

Skills: SQL

See more: what is an sql query, sql statements list, sql queries for dummies, complex sql query examples, sql query examples with answers, sql query examples from multiple tables, basic sql queries pdf, sql queries examples, query simple sql, simple sql query, simple sql query creator, sql query select last date customer order, asp sql query write html, sql query select employees age dob, write sql query display job title employees manager, sql query select latest accounts, sql query select salary 1st sep 30th sep, vbscript write file sql select, write sql query days data, write sql query display day system

About the Employer:
( 2 reviews ) Cicero, United States

Project ID: #17521766

Awarded to:

sweetykantha04

Hello! I am very happy to work with you and would like to fix the last query for you as needed. Thanks for the work again.

$25 USD in 1 day
(3 Reviews)
2.5

24 freelancers are bidding on average $19 for this job

it2051229

Hi there, I checked your ERD and your required query, I can definitely write the query for you if you're interested. Let me know. Thanks.

$15 USD in 0 days
(60 Reviews)
5.1
mekiho

Hi, dear. As a expert database programmer, I can finish this within 2 hours. Please contact me and let us start. Thanks.

$25 USD in 1 day
(1 Review)
2.4
$25 USD in 1 day
(1 Review)
2.1
kypergio

Hey dude I'm ready to help you right now. I'm software engineer and I know, of course, SQL syntax. I will be happy to help you.

$15 USD in 1 day
(2 Reviews)
2.6
dev54369

7 years experience in Microsoft technologies: 1. ASP.NET/MVC with C# and VB.NET 2. HTML, JavaScript,jQuery,CSS, Ajax 3. Desktop applications with C# and VB.NET 4. Web Services, WCF, and Entity Framework,LIN More

$20 USD in 1 day
(1 Review)
1.3
shiningdevelopor

⭐⭐⭐⭐⭐⭐⭐Hello, I can finish your project in short time⭐⭐⭐⭐⭐⭐⭐ Look my profile My speed is rocket speed. if you see my profile, you will be amazing.. :) Because We have finished serveral big project for short time. More

$25 USD in 1 day
(0 Reviews)
0.0
jperusan

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

$10 USD in 1 day
(0 Reviews)
0.0
frlncrsZviDAyqG

Hello From the schema provided please confirm that ProductService, Quantity and EmployeeID are the only 3 fields to be output consolidated and ordered by ProductService for employee ID 1 Please message confirmati More

$20 USD in 1 day
(0 Reviews)
0.0
$20 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
anilpulikoden

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.

$10 USD in 1 day
(0 Reviews)
0.0
jslabnl

Select [login to view URL] as ProductService, [login to view URL], [login to view URL] from ProductAndServices ps join InvoiceDetails id on ps.PSID=[login to view URL] join Invoice i on i.InvID=[login to view URL] join Employees e on e.EmpID=i More

$15 USD in 1 day
(0 Reviews)
0.0
itdevelopersin

Hi I have read your project description, lets start this. If you have any questions for me please let me know will be glad to help. Thanks and Regards

$10 USD in 1 day
(1 Review)
0.0
$10 USD in 1 day
(0 Reviews)
0.0
Intranetman

HI, I AM A PHP PROGRAMMER AND WEB DEVELOPER. I HAVE A LOT OF EXPERIENCE IN PHP CODING AND DIFFERENT KINDS OF SCRIPTING LANGUAGES. I HAVE DEVELOPED MANY DYNAMIC WEBSITES USING PHP AND MYSQL. I CAN MAKE SURE WHAT YOU More

$20 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
chaupham520

Dear Sir, I'm willing to help you more in case you need to help to write query about your DB, even thought after finished this project, just send me a message if you need help. Looking forward to be your selector an More

$15 USD in 1 day
(0 Reviews)
0.0
neostar22356

Hello Sir, My slogan is "Ensure BEST QUALITY, Always Keep DEADLINE, Accept PROPER PRICE according to a Client". I have more than 15 years experience in SQL query, so I am very familiar with your requirements. I am a More

$30 USD in 1 day
(0 Reviews)
0.0
PARMOD89

Hey I have read & understood your requirements. I have already done similar kind of jobs. I have 2 year of experience with Sql queries. I have plenty of time available with me. So i hope you will open a PM for disc More

$10 USD in 1 day
(0 Reviews)
0.0
randeepnamdhari

Hi there! I am interested in your job and I am familiar with SQL. I can do this easy job. You can pay after the job done. Thanks

$20 USD in 1 day
(0 Reviews)
0.0