JSFiddle - React, Tailwind, and code Playground

HTML

<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.8.0/xlsx.full.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/alasql.js"></script>
<xmp id="output"></xmp>

JavaScript

print('I would expect to get [{a1:1}] but I get []:')

alasql('create table t1 (a1 double precision, b1 double precision);')
alasql('create table t2 (a2 double precision, b2 double precision);')

alasql.tables.t1.data = [
    { "a1": 1.0, "b1": 1.0 },
    { "a1": 1.0, "b1": 2.0 },
    { "a1": 2.0, "b1": 3.0 },
    { "a1": 3.0, "b1": 1.0 },
    { "a1": 3.0, "b1": 2.0 },
    { "a1": 3.0, "b1": 3.0 },
  ];

alasql.tables.t2.data = [
    { "a2": 7.0, "b2": 7.0 },
    { "a2": 7.0, "b2": 8.0 }
  ];


var res = alasql('select a1 from t1 group by a1 having exists (select a2 from t2 group by a2 having sum(1+0*b1) = 2);')


print(res)
	






function print(x){
    document.getElementById('output').textContent += JSON.stringify(x,  null, '\t')+"\n";
}
print('AlaSQL v'+alasql.version)