Simpify my query

hi can you help me simplifying my query:

SELECT SUM(NewQuote.total*.20) + (SELECT SUM((Invoice.invoiceTotal-NewQuote.total)*.30)
FROM `NewQuote`
INNER JOIN Invoice ON Invoice.quoteID=NewQuote.quoteID
INNER JOIN schedules ON schedules.quoteId=NewQuote.quoteID
WHERE (rem=1 OR rem=2)
AND (schedules.redo IS NULL)
AND invoiceTotal!=0
AND (DATE_FORMAT(date_start, '%m/%d/%Y') >= '07/01/2016')
AND...

Simpify my query

from Databases http://ift.tt/29Q0kLt
via IFTTT

Share :

Tweet

✚

Related Post