MySQL 5.5

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE TEST_TABLE1(
COL11 INTEGER,
COL12 VARCHAR(10),
col3 integer);
CREATE TABLE TEST_TABLE2(
COL11 INTEGER,
COL12 VARCHAR(10));
CREATE TABLE TEST_TABLE3(
COL11 INTEGER,
COL12 VARCHAR(10),
col13 integer);
SELECT A.* FROM  TEST_TABLE1 A
LEFT JOIN  TEST_TABLE2 B
ON A.COL11 = B.COL11
left join TEST_TABLE3 C
on B.COL12 =C.COL12
INNER JOIN TEST_TABLE3 C
ON A.COL3 = C.COL13;
Not unique table/alias: 'C'