salix/db/routines/vn/procedures/prepareClientList.sql

DELIMITER $$
CREATE OR REPLACE DEFINER=`vn`@`localhost` PROCEDURE `vn`.`prepareClientList`()
BEGIN
	
	/*
	 * Require la tabla tmp.ticket(id,clientFk)
	 */
	
	DROP TEMPORARY TABLE IF EXISTS tmp.client;
	CREATE TEMPORARY TABLE tmp.client
		(PRIMARY KEY (id))
		ENGINE = MEMORY
		SELECT DISTINCT clientFk id
			FROM tmp.ticket; 
END$$
DELIMITER ;