BEGIN  
    DECLARE done, cid_out INT;
    DECLARE title_out VARCHAR(500);
    DECLARE cur1 CURSOR for select A.cid, B.title from contract_account A join service B on A.sid=B.id where cid=369;  
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
    OPEN cur1; 
   
    SET done = 0;   
  
    WHILE done = 0 DO  
    	FETCH cur1 INTO cid_out, title_out; 
        SELECT cid_out, title_out;
    END WHILE;     
    CLOSE cur1;
END;

BEGIN  
    DECLARE yy, mm, done, cid_out INT;
    DECLARE title_out VARCHAR(500);
    DECLARE cur1 CURSOR for select A.yy, A.mm, A.cid, B.title from contract_account A join service B on A.sid=B.id where cid=369;  
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
    OPEN cur1;
    SET done = 0;   
    CREATE TEMPORARY TABLE new_t (yy INT, mm INT, cid_out INT, title_out VARCHAR(500));
    WHILE done = 0 DO  
    	FETCH cur1 INTO yy, mm, cid_out, title_out; 
        insert into new_t values(yy, mm, cid_out, title_out);        
    END WHILE;     
    CLOSE cur1;
    SELECT yy, mm, cid_out, title_out from new_t;
END

SELECT A.yy, A.mm, A.cid, B.title FROM contract_account A JOIN service B ON A.sid=B.id WHERE cid=369

CREATE DEFINER = 'root'@'localhost' PROCEDURE `avk_report_sverka`()
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN  
    DECLARE yy, mm, done, cid_out INT;
    DECLARE title_out VARCHAR(500);
    DECLARE cur1 CURSOR FOR SELECT A.yy, A.mm, A.cid, B.title FROM contract_account A JOIN service B ON A.sid=B.id WHERE cid=369;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
    OPEN cur1;
    SET done = 0;   
    CREATE TEMPORARY TABLE new_t (yy INT, mm INT, cid_out INT, title_out VARCHAR(500));
	FETCH cur1 INTO yy, mm, cid_out, title_out;
    WHILE done = 0 DO   
        INSERT INTO new_t VALUES(yy, mm, cid_out, title_out);
        FETCH cur1 INTO yy, mm, cid_out, title_out;        
    END WHILE;     
    CLOSE cur1;
    SELECT DISTINCT yy, mm, cid_out, title_out FROM new_t;
END;