sqlite

create table a (x integer, y integer);
create table b (x integer, y integer);

select foo2.x from (
    select foo1.x, foo1.y from (
        select a.x as x, b.y as y from a join b on a.x = b.x
    ) as foo1
) as foo2 ;