Anonymous

DELIMITER //CREATE procedure min_frm_friends(IN sdate date, IN edate date) BEGIN          SELECT MAX(date),time,Personal.pc.firstname,Personal.pc.lastname,number,count(minutes) AS minutes              FROM phonelog,Personal.pc              WHERE phonelog.number IN(Personal.pc.businessphone,Personal.pc.mobilephone,Personal.pc.homephone)                  AND sdate < date and edate > date              GROUP BY firstname ORDER BY minutes; END//DELIMITER ;