MYSQL Query Fix
$10-30 USD
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'
Nº del proyecto: #18343399
Sobre el proyecto
12 freelancers están ofertando un promedio de $35 por este trabajo
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
I have check your query, hope I can complete your request mostly maximum of between 2 days with effective way.