CREATE TABLE T1( REAL, JSON, c3 ); CREATE TABLE T2(c1 ); CREATE TABLE T3(c1 , c2 ); INSERT INTO T1 VALUES (933, '{"k": 4}', 131); INSERT INTO T3 VALUES (564, 406); SELECT c. c1 FROM T1 LEFT JOIN T2 b ON c3 = b.c1 LEFT JOIN T3 c ON b.c1 WHERE c.c1