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