Hello,
I'm attempting to learn MySql, first issue I found, It doesn't do TRANSFORM like access,
Here's my old SQL from access, I need to change it into standard SQL:
TRANSFORM nz(count(*),0) AS FoundMonth
SELECT month(dDateFound) AS [MONTH], Count(*) AS [Found]
FROM Q_Defects INNER JOIN...