Hi mga KAPHC,
Pwede pahelp?
Ano mali dito sa query ko sa mysql.
Select usual.emp_id, lastname, firstname, comm_count From tbl_employees
b inner join
(SELECT emp_id, COUNT(*) AS comm_count
FROM tbl_performance WHERE perf_category = 'Commendation' AND YEAR(perf_datetime) =...