MYSQL Query Fix

$10-30 USD

Dokončeno

Zveřejněno

před více než 5 roky

$10-30 USD

Zaplaceno při doručení

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

IČ projektu: 18343399

O projektu

12 nabídky

Vzdálený projekt

Aktivní před 5 roky

Chcete si vydělat nějaké peníze?

E-mailová adresa

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec

Získejte za svou práci zaplaceno

Načrtněte svůj návrh

Registrace a podávání nabídek je zdarma

Uděleno:

@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 v 0 dni

5,0

(247 recenze)

7,5

12 freelanceři nabízejí v průměru $35 USD za tuto práci

@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 v 1 dni

4,8

(105 recenze)

6,6

@adeeladeel1234

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

$35 USD v 1 dni

5,0

(40 recenze)

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 v 1 dni

5,0

(47 recenze)

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 v 1 dni

5,0

(7 recenze)

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 v 1 dni

5,0

(5 recenze)

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 v 2 dnech

0,0

(0 recenze)

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 v 1 dni