framework/resources/Functional/complex/json/complex155.q

select a.id, b.sia, a.sfa[0], b.soa[0].`in` from `complex.json` a inner join `complex.json` b on a.sia[3]=b.sia[3] order by a.id desc limit 20;