Suoritettu

SQL - Fix Outer Join Issue

We have a script that is not returning the correct values per the following requirements (refer to attached files for reference).

#1. Records should be displayed for all records appearing in sales_order_details that match records in pick_history (sub query).

#2. Records in pick_history should also be matched against shipment_details. If no match exists in shipment_details, all records from #1 should still display and records from #2 should display 0 (zero).

#1 is working fine. However, when we add a left outer join for shipment_details in #2, we get incorrect records returned.

We need someone to fix the query to display records correctly as mentioned above. See attached database and script files for more information.

Taidot: SQL, MySQL

Näytä lisää: sql 2005 report requested requires information, fix shopping cart issue website, fix browser compatibility issue, sql query select last date customer order, write left outer join using java struts, ejb21 left outer join, input screen takes clients information order, fix freelancer server issue, sql server 2000 gathering database information, post goods issue required order cash cycle, sql server gather 2000 collation information, fix joomla email issue, fix xhtml height issue, billing information order review page magento, fix css chrome issue, fix joomla css issue, information order processing application

Tietoa työnantajasta:
( 118 arvostelua ) huntley, Canada

Projektin tunnus: #22802908

Myönnetty käyttäjälle:

justTry

Hi! I'll conduct some tests and will get back with any queries I might have or a ready solution. Regards, Dobri EDIT 2019-12-11 02:48 GMT+2: I have the fixed query ready.

$25 USD 1 päivässä
(70 Arvostelua)
5.4

46 freelanceria on tarjonnut keskimäärin 30$ tähän työhön

mahmoudgamal008

I created the database from the attached files, and tried the query. The matching rows from the table "sales_order_details" and the first query is 27 rows, and then the whole query returned exactly the same 27 rows. I Lisää

$30 USD 7 päivässä
(39 arvostelua)
5.5
abugosia

Hello, I'm Abu Gosia. I'm interesting in your project very well. I m quite well experienced in these jobs. Let's go ahead with me. Thanks

$30 USD 1 päivässä
(42 arvostelua)
5.7
dreammate0621

Hello! I am a MySQL expert. I have checked your project description. If you hire me, I am gonna do my best. I guarantee the perfect result. I will be right here waiting for you. Best regards.

$20 USD 1 päivässä
(8 arvostelua)
4.5
an4rei

Hello! I can deal with this as well. Just ping me if you're interested after you finish testing my other work. Thanks!

$30 USD 1 päivässä
(14 arvostelua)
4.6
jayantavkumar

Proposal - You can expect any kind of work on SQL from me. Let me know if you want to discuss further. I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various Lisää

$30 USD 1 päivässä
(17 arvostelua)
4.6
germancasais

Hello. I can help you. I have more than 10 years of experience in database administration and querying over MySQL and SQL Server. Thanks, regards

$30 USD 1 päivässä
(4 arvostelua)
4.2
sreenivas2903

Hi i am expertise in sql queries if u are interested ping me i wil lsolve this quickly tell me ur bid.

$35 USD 1 päivässä
(14 arvostelua)
4.3
dimuthufr

Dear sir, I am senior software engineer in sri lanka with skill of PHP, Laravel, Asp.net , C#, I would like to complete your project as your needs. Please contact me for more details Thanks

$25 USD 1 päivässä
(10 arvostelua)
3.9
vw7590795vw

Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 10 years experience in MS SQL Server and 7.3 years experience in SSRS, SSIS (Import / Export). Please let me know more details and when w Lisää

$30 USD 1 päivässä
(20 arvostelua)
4.0
LeeSong1025

Hi, Nice to meet you! I am very interesting your project and I am confident of I can help your job. I am confident of this project as I'm a professional mysql expert with over 7 years of experience. Seems to be an inte Lisää

$30 USD 1 päivässä
(8 arvostelua)
3.5
alexand1025

⭐Hi, ⭐ I am a SQL expert and I can do this job successfully within 20 mins. I have rich experience 10+ years in web development and I can say that's exactly what I specialize in. You will satisfied on my work. I am rea Lisää

$30 USD 7 päivässä
(14 arvostelua)
3.8
goodwork20k

I am good in sql stuff along with automation and development, please let me know if you are good to award this project to me

$30 USD 1 päivässä
(3 arvostelua)
3.3
adricabrelles

Hi I am a Senior DBA with more than 15 years experience in sql. I can help you. Regards.

$30 USD 1 päivässä
(10 arvostelua)
3.7
TEKSCENT

hi ,i have around 10 years of experience in SQL developement and working as team lead.I can surely help you in this scenario

$30 USD 1 päivässä
(4 arvostelua)
3.4
Panda393

Hello. i will do it in 1hrs. I am senior developer with rich experience in sql. I read your project description carefully. If you choose me, I'll provide satisfied result you want Thank you

$30 USD 1 päivässä
(1 arvostelu)
3.3
ayyar1

Sir, I read through the job details of your project, I check your attached files and am I am absolutely sure that I can do this project very well. I am a MySQL expert databases and I can correct the queries you need. I Lisää

$30 USD 3 päivässä
(6 arvostelua)
2.9
ZishanChuhan

I am expert in DB Design and implementation. I have good expertise in SQL and can do the task as per your requirements.

$30 USD 2 päivässä
(4 arvostelua)
2.6
SqlDevelopment

I have deep and proven experience in T-SQL development and debugging of queries with huge complexity. My total MSSQL Experience is 10+ years. Five of them was within USA company as Senior SQL/BI Developer. My everyday Lisää

$30 USD 1 päivässä
(5 arvostelua)
2.5
JamesRobert1010

Hello dear. I am a expert of MYSQL . I have rich experience for more than 10+ years. I can satisfy you with a good result for a short time. Also I am ready to start work for you right now. Please feel free contact me a Lisää

$25 USD 1 päivässä
(4 arvostelua)
2.6
gpnr2017

Hello, Hope you are doing well. I have gone through the project requirement and find my self in good position to complete this project using my expertise in sql. I would very much enjoy having the opportunity to talk Lisää

$20 USD 1 päivässä
(4 arvostelua)
2.2