MySQL Extract Date & Concat issue

rcowen00
rcowen00 used Ask the Experts™
on
When I run this quey, I get "#1305 - FUNCTION loanmod1_ermqc2.CONCAT does not exist".  What am I doing wrong.  Thank you.
SELECT branch.branchName, CONCAT (EXTRACT(MONTH FROM trackingDate),'-', EXTRACT(YEAR FROM trackingDate)) AS trackingMth, COUNT(auditID) as Loans
FROM loan 
JOIN audit USING (loanKey)
JOIN branch USING (branchKey)

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:
please try to remove the space befor the (


SELECT branch.branchName, CONCAT(EXTRACT(MONTH FROM trackingDate),'-', EXTRACT(YEAR FROM trackingDate)) AS trackingMth, COUNT(auditID) as Loans
FROM loan 
JOIN audit USING (loanKey)
JOIN branch USING (branchKey)

Open in new window

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial