k8REAMuc

1DELIMITER //
2CREATE PROCEDURE contributors_for_department
3(IN con CHAR(20))
4BEGIN
5CREATE TEMPORARY TABLE IF NOT EXISTS temp_idea_by_comment as
6SELECT COUNT(Comment_Id) as count,i.Idea_Id FROM `ideas` i LEFT JOIN comments c ON c.Idea_Id = i.Idea_Id GROUP BY i.Idea_Id;
7
8SELECT i.* FROM temp_idea_by_comment tmp_i INNER JOIN ideas i ON i.Idea_Id = tmp_i.Idea_Id WHERE tmp_i.count = 0;
9
10END//
11DELIMITER //