search

AlaSQL / alasql

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.
http://alasql.org
MIT License
7.01k stars 650 forks source link

Sub-queries/nested queries #1809

Closed kshitijnagpal closed 11 months ago

kshitijnagpal commented 11 months ago

How do I write sub-queries like below?

SELECT * FROM table1 tbl WHERE tbl.col1 < (SELECT MAX(serial_number) from table2)

I tried using VALUE OF in the sub-query as described here: https://github.com/AlaSQL/alasql/wiki/Value but couldn't get it to work

mathiasrw commented 11 months ago

Question about how to ...