<div>
<div class="content wysiwyg-content">
When I run this quey, I get &quot;#1305 - FUNCTION loanmod1_ermqc2.CONCAT does not exist&quot;. &nbsp;What am I doing wrong. &nbsp;Thank you.<br />

<pre><code id="code-8168687">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)</code></pre>
</div>
</div>


When I run this quey, I get "#1305 - FUNCTION loanmod1_ermqc2.CONCAT does not exist".  What am I doing wrong.  Thank you.

MySQL Extract Date &amp; Concat issue

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Extract Date &amp; Concat issue

MySQL Extract Date & Concat issue