Listaár számlálás

v_listaar.sql

BEGIN DECLARE v_listaar INT;

 DECLARE v_euro FLOAT;

 DECLARE v_ar_eur FLOAT;


SELECT listaar,
       arEUR INTO v_listaar,
                  v_ar_eur
FROM products
WHERE ID = p_id;


SELECT Aktualis_arfolyam INTO v_euro
FROM arfolyam
WHERE ID = 1;

 RETURN IFNULL(v_listaar, v_euro*v_ar_eur);

 END