Link to home
Create AccountLog in
Avatar of rcowen00
rcowen00Flag for United States of America

asked on

MySQL Extract Date & Concat issue

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

ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer