MYSQL Query Fix

$10-30 USD

Ολοκληρώθηκε

Αναρτήθηκε

πάνω από 5 χρόνια πριν

$10-30 USD

Πληρωμή κατά την παράδοση

I have a mysql query I am working on, part of it is correct and part of of it is not. I need help correcting the issue. I can provide sample data and queries. This is the main query in its current state. amtbill column does not sum correctly. I'm sure it is the type of join but I am not sure how to fix. SELECT [login to view URL], [login to view URL], [login to view URL], [login to view URL], ( [login to view URL] ), ( [login to view URL] + [login to view URL] ) AS amtbill, [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL] AS ctrackerzip, [login to view URL], [login to view URL], [login to view URL], [login to view URL] FROM needsPrice LEFT JOIN notes LEFT JOIN schedule ON [login to view URL] = [login to view URL] ON [login to view URL] = [login to view URL] LEFT JOIN data ON [login to view URL] = [login to view URL] LEFT JOIN advdata ON [login to view URL] = [login to view URL] WHERE [login to view URL] BETWEEN '2018-12-01' AND '2018-12-10' Below is how I fact check the data. By using a SUM I can tell amtbill is wrong. SELECT [login to view URL], [login to view URL], [login to view URL], [login to view URL], SUM( [login to view URL] ) , SUM( [login to view URL] + [login to view URL] ) AS amtbill, [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL] AS ctrackerzip, [login to view URL], [login to view URL], [login to view URL], [login to view URL] FROM needsPrice LEFT JOIN notes LEFT JOIN schedule ON [login to view URL] = [login to view URL] ON [login to view URL] = [login to view URL] LEFT JOIN data ON [login to view URL] = [login to view URL] LEFT JOIN advdata ON [login to view URL] = [login to view URL] WHERE [login to view URL] BETWEEN '2018-12-01' AND '2018-12-10'

MySQL

PHP

SQL

Ταυτότητα εργασίας: 18343399

Σχετικά με την εργασία

12 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 5 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

Βραβεύτηκε στον/στην:

@sumon355

Hello, As an expert in SQL, i am very much interested to fix the query. Please send me the database or related tables with data so that i can run the query and fix it. I am available now to work on it, if you want i can work on your PC. Thanks

$24 USD σε 0 ημέρα

5,0

(247 αξιολογήσεις)

7,5

12 freelancers δίνουν μια μέση προσφορά $35 USD για αυτή τη δουλειά

@maxtechsl

Hello, I have gone through the sql. I understood that fetching the tables by join is somewhere leading to incorrect data and want to know about the purpose of each tables, when datas are stored & what is the output u want. Please open message board for further discussion so that i can solve the issue. Thanks Ramesh

$25 USD σε 1 ημέρα

4,8

(105 αξιολογήσεις)

6,6

@adeeladeel1234

I can resolve your issue in an hour please send me message to discuss

$35 USD σε 1 ημέρα

5,0

(40 αξιολογήσεις)

5,5

@anj180190

Hello there, Hope you are doing well !! I CAN FIX IT NOW. It's straight to your referenced post I am an expert in MYSQL and having good experience over queries. I can fix it. I'm interested in your project. Please send me a message so that we can discuss more. Looking forward to hear more from you for any query. Sincerely, Ashish Sr. WP Developer

$25 USD σε 1 ημέρα

5,0

(47 αξιολογήσεις)

5,0

@Apisylux

Hello Sir, I can review your query. Please provide me the copy of database and the query. I'll complete it and provide you. Till then don't award me the project. So you may have assurity if i can do that or not. (I know customer's insecurity that's why) I am available and can start it right away

$30 USD σε 1 ημέρα

5,0

(7 αξιολογήσεις)

4,7

@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 WORDPRESS AND MYSQL QUERY. I CAN MAKE SURE WHAT YOU NEED. PLEASE SHARE FURTHER INFORMATION. THANKS

$33 USD σε 1 ημέρα

5,0

(5 αξιολογήσεις)

2,2

@samsulh89

I have check your query, hope I can complete your request mostly maximum of between 2 days with effective way.

$17 USD σε 2 ημέρες

0,0

(0 αξιολογήσεις)

0,0

@mlee8585

This looks fairly straightforward, especially if you already know the expected output. Depending on the relationship between the tables, there could be some normalization required in order to get the correct amounts summed. It will be much easier to determine the cause of the issue with some sample data.

$20 USD σε 1 ημέρα