DROP PROCEDURE IF EXISTS sp1;

DELIMITER $$

CREATE PROCEDURE sp1(IN para1 INT, IN para2 INT,IN para3 INT)

BEGIN

INSERT INTO table100 VALUES(
NULL, #AaS_id, Auto_Increment
DEFAULT, #AaS_ts, Def
SELECT info1 FROM table2 WHERE id1 = para1,
SELECT info2 FROM table3 WHERE id2 = para2,
para3);

END$$

DELIMITER ;