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

DELIMITER $$
CREATE OR REPLACE DEFINER=`vn`@`localhost` PROCEDURE `vn`.`worker_getSector`()
BEGIN

/**
 * Obtiene el sector del usuario conectado
*/

	SELECT s.id,s.description,s.warehouseFk
	FROM sector s
		JOIN operator o ON o.sectorFk  = s.id 
	WHERE o.workerFk = account.myUser_getId();

END$$
DELIMITER ;