1 2 3 4 5 6 7 8
--!syntax_pg select * from (select 1 as x) as a , (select 1 as y) as b , (select 1 as z) as c where a.x = c.z and a.x = b.y