rcowen00
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)
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.