DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteAll`(IN `tmpGroup` INT)
    NO SQL
BEGIN
    DELETE groups, transaction,expensestable
    FROM groups
    INNER JOIN transaction ON groups.groupID=transaction.groupID
    INNER JOIN expensestable ON expensestable.expensesTableID=transaction.expensesTableID
    WHERE groups.groupID = tmpGroup;
END$$
DELIMITER ;