- --!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;
|