--!syntax_pg select * from (select 1 as x) a inner join (select 1 as y) b on a.x=b.y; select x from (select 1 as x) a inner join (select 1 as y) b on a.x=b.y; select a.x from (select 1 as x) a inner join (select 1 as y) b on a.x=b.y; select a.* from (select 1 as x) a inner join (select 1 as y) b on a.x=b.y;