Example of non-working code

procedure-result-set.sql

DELIMITER //

CREATE PROCEDURE p1()
BEGIN
    DECLARE ids INT;
    SELECT id FROM t4 WHERE t5_id = 8 INTO @ids;
    
    SELECT
        t3.*
    FROM
        t1
        INNER JOIN t2 ON t2.t1_id = t1.id
        INNER JOIN t3 ON t3.id = t1.t3_id
    WHERE
        t2.t4_id IN (@ids);
END;
//

DELIMITER ;