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) = YEAR(CURDATE()) AND
MONTH(perf_datetime) = MONTH(CURDATE())
GROUP BY emp_id) as usual on usual.emp_id = b.emp_id
c inner join
(SELECT emp_id, COUNT(*) AS poor_perf
FROM tbl_performance WHERE perf_category = 'Poor Performance' AND YEAR(perf_datetime) = YEAR(CURDATE()) AND
MONTH(perf_datetime) = MONTH(CURDATE())
GROUP BY emp_id) as yeah on usual.emp_id = c.emp_id
nag eerror eh.
pag di ko sinama ung 'c inner join' then the rest ok naman. may result.
Thanks in advance.
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) = YEAR(CURDATE()) AND
MONTH(perf_datetime) = MONTH(CURDATE())
GROUP BY emp_id) as usual on usual.emp_id = b.emp_id
c inner join
(SELECT emp_id, COUNT(*) AS poor_perf
FROM tbl_performance WHERE perf_category = 'Poor Performance' AND YEAR(perf_datetime) = YEAR(CURDATE()) AND
MONTH(perf_datetime) = MONTH(CURDATE())
GROUP BY emp_id) as yeah on usual.emp_id = c.emp_id
nag eerror eh.
pag di ko sinama ung 'c inner join' then the rest ok naman. may result.
Thanks in advance.