blob: fad3522dd9d7465068942f47ffbdd64ef05f3d97 [file]
select a.id, b.sfa, a.soa[1].fl from `complex.json` a inner join `complex.json` b on a.sfa[0]=b.sfa[1] order by a.id limit 20;