I apologize for the incomplete information. Here are my two sp: SP1 -
DELIMITER $$
PERMISSION PROCEDURE IF SP1$$ SP1EXISTS A CREATION PROCEDURE (InputCustomerID int, InputOrderID int) BEGIN
// Some sql statements and finally put them in the actual table tb1 in the database
END $$
DELIMITER;
SP2 - In SP2, I assign an input value to the parameters SP1.
DELIMITER $$
PERMISSION PROCEDURE IF EXISTING SP2$$ CREATION PROCEDURE SP2() BEGIN
Declare InputCustomerID int; Declare InputOrderID int; declare OrderStateDate Datetime;
CustomerID InputCustomerID Cusomers CustomerID NOT IN ( FK_CustomerID CustomerOrders) IsApproved = True CustomerID IN ( FK_CustomerID CustomerProductOrders Date (OrderStartDate) = Date (Now()));
OrderID InputOrderID CustomerOrders Where FK_CustomerID NOT IN ( FK_CustomerID CustomerProdcutOrders) IsApproved = True Date (OrderStartDate) = Date (Now());
SP1 (InputCustomerID, InputOrderID);
END $$
DELIMITER;