DELIMITER //

CREATE DATABASE m5
//
USE m5

CREATE PROCEDURE proc4 ()
BEGIN
        CREATE TEMPORARY TABLE t4 (ID INTEGER PRIMARY KEY, VALUE INTEGER NOT NULL);
        CREATE TEMPORARY TABLE t5 (ID INTEGER PRIMARY KEY, VALUE INTEGER NOT NULL);
        INSERT INTO t4 VALUES(1,4);
        INSERT INTO t4 VALUES(2,5);
        INSERT INTO t4 VALUES(3,6);
        INSERT INTO t5 VALUES(1,7);
        INSERT INTO t5 VALUES(2,8);
        INSERT INTO t5 VALUES(3,9);
  SELECT DISTINCT t4.ID as ONE, t4.VALUE as TWO, t5.VALUE as THREE FROM t4, t5 WHERE t4.ID=t5.ID;
END;
//