blob: 1e91dc37b814043c1c3c880a4af85e9552168930 [file] [log] [blame]
select a.id, b.sia, a.sfa[0], b.soa[0].`in` from `complex.json` a inner join `complex.json` b on a.sia[2]=b.sia[3] order by a.id limit 20;