SELECT Count(*) as total, UR.name,C.comment_assin FROM comment C INNER JOIN user_reg UR on C.comment_assin=UR.emp_id WHERE C.commentstatus NOT IN('0','3') group by comment_assin ORDER BY C.id DESC
SELECT Count(*) AS TOTAL , UR.name,C.comment_assin FROM comment C INNER JOIN user_reg UR on C.comment_assin=UR.emp_id WHERE C.commentstatus ='3' group by C.comment_assin ORDER BY C.id DESC
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)