Closed HELP MYSQL NESTED QUERY JOIN

[pakseyt]

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.

 

[MiRAGEDota]

"GROUP BY (emp_id)"

 

[pakseyt]

"GROUP BY (emp_id)"

thanks sir kaso ayaw padin

 

[JustFriends]

Baka pwede ka po makabigay ng jsfiddle para matest po namin kung ano pong data ang dapat mahugot.

 

[aa1012]

ano ang error na lumalabas. yun ang importante di mo sinama sa tanong mo.


pero based sa analysis ko sa query mo, baka ganto dapat yan:

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
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 = yeah.emp_id

advise ko lang, magbasa ka ng proper na coding syntax ng mysql or sql server. makakatulong yun sa readability ng code mo. ang gulo e. katulad ng condition mo sa perf_category, bakit nakafix yan? ugaliin mong maglagay ng parameter. mag declare ka ng variable mo at dun mo ilagay yung value.