DROP VIEW IF EXISTS v1;

DROP TABLE IF EXISTS t1, t2, t3;

CREATE TABLE t1 (i INT);

INSERT INTO t1 VALUES (3),(2);

CREATE TABLE t2 (j INT);

INSERT INTO t2 VALUES (8),(3),(3);

CREATE TABLE t3 (k INT);

INSERT INTO t3 VALUES (1),(8);

SELECT * FROM t1 LEFT JOIN ( SELECT t2.* FROM t2 INNER JOIN t3 ON ( k = j ) ) AS alias1 ON ( i = j )  ;

CREATE OR REPLACE VIEW v1 AS 

SELECT * FROM t1 LEFT JOIN ( SELECT t2.* FROM t2 INNER JOIN t3 ON ( k = j ) ) AS alias1 ON ( i = j )  ;

SELECT * FROM v1; 

MariaDB [test]> SELECT * FROM t1 LEFT JOIN ( SELECT t2.* FROM t2 INNER JOIN t3 ON ( k = j ) ) AS alias1 ON ( i = j )  ;

+------+------+

| i    | j    |

+------+------+

|    3 | NULL |

|    2 | NULL |

+------+------+

2 rows in set (0.00 sec)

MariaDB [test]> 

MariaDB [test]> CREATE OR REPLACE VIEW v1 AS 

    -> SELECT * FROM t1 LEFT JOIN ( SELECT t2.* FROM t2 INNER JOIN t3 ON ( k = j ) ) AS alias1 ON ( i = j )  ;

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> 

MariaDB [test]> SELECT * FROM v1; 

+------+------+

| i    | j    |

+------+------+

|    3 |    3 |

|    3 |    3 |

|    2 | NULL |

+------+------+

3 rows in set (0.00 sec)