DROP PROCEDURE IF EXISTS test_procedure;

CREATE PROCEDURE test_procedure()
BEGIN	
    #prepare	
    DROP TABLE IF EXISTS test_table_1;	
    DROP TABLE IF EXISTS test_table_2;	
    DROP TABLE IF EXISTS test_table_3;		

    CREATE TABLE test_table_1(id INT);	
    CREATE TABLE test_table_2(id INT);	
    CREATE TABLE test_table_3(id INT);		
    
    #problem statement	
    SELECT * FROM test_table_1 t1 	
    LEFT JOIN test_table_2 t2 		 
         JOIN test_table_3 t3 ON t3.id=t2.id		 
         ON t1.id=t2.id;		
END