MYSQL Query Fix

Completado Publicado hace 5 años Pagado a la entrega
Completado Pagado a la entrega

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

Nº del proyecto: #18343399

Sobre el proyecto

12 propuestas Proyecto remoto Activo hace 5 años

Adjudicado a:

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 c Más

$24 USD en 0 días
(247 comentarios)
7.5

12 freelancers están ofertando un promedio de $35 por este trabajo

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 w Más

$25 USD en 1 día
(105 comentarios)
6.6
adeeladeel1234

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

$35 USD en 1 día
(40 comentarios)
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 Más

$25 USD en 1 día
(47 comentarios)
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 Más

$30 USD en 1 día
(7 comentarios)
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 S Más

$33 USD en 1 día
(5 comentarios)
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 en 2 días
(0 comentarios)
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 Más

$20 USD en 1 día
(0 comentarios)
0.0