MrTV
asked on
sum mysql
SELECT
sale.preselRef,
sale.name,
sale.saledate,
sale.grandtotal,
sale.secid,
sale.invoicetype,
sum (sellnote.Paid),
sellnote.CreCard,
sellnote.PCheck
FROM
sale
left outer join sellnote on sale.preselRef = sellnote.Code
WHERE
sale.`timestamp` > curdate() and sellnote.`timestamp` > curdate()
group by sellnote.Code
[Err] 1630 - FUNCTION asianonline.sum does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual
sale.preselRef,
sale.name,
sale.saledate,
sale.grandtotal,
sale.secid,
sale.invoicetype,
sum (sellnote.Paid),
sellnote.CreCard,
sellnote.PCheck
FROM
sale
left outer join sellnote on sale.preselRef = sellnote.Code
WHERE
sale.`timestamp` > curdate() and sellnote.`timestamp` > curdate()
group by sellnote.Code
[Err] 1630 - FUNCTION asianonline.sum does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual
ASKER
Hi kalmax
i wany to sum sellnote.Paid
i wany to sum sellnote.Paid
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
would you please elaborate the question