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.
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.
46 freelanceria on tarjonnut keskimäärin 30$ tähän työhön
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.
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
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