ALASQL SELECT JOINED

by mgoetzke

HTML

<script src="https://cdnjs.cloudflare.com/ajax/libs/alasql/0.3.1/alasql.min.js"></script>
     <script src="alasql.min.js"></script>
     <button onclick="newdb()">
       NEW DB
     </button>
     <button onclick="opendb()">
       OPEN DB
     </button>
     <p>Select CSV file to read:</p>
     <input id="readfile" type="file" onchange="loadFile(event)"/>
     <input type="file" onchange="loadFile2(event)"/>
     <input type="file" onchange="loadFile3(event)"/>
     <input type="file" onchange="loadFile4(event)"/>
     
     <button onclick="query()">
       QUERY
     </button>
     <script>
        function newdb(){
          try{
            //alasql('DROP INDEXEDDB DATABASE IF EXISTS iris');
            alasql('CREATE INDEXEDDB DATABASE IF NOT EXISTS iris');
            alasql('ATTACH INDEXEDDB DATABASE iris');
            alasql('USE iris');
          } catch (err){
            console.log(err,err.stack)
          }
        }
        function opendb(){
          try{
            alasql('ATTACH INDEXEDDB DATABASE iris');
            alasql('USE iris');

          } catch (err){
            console.log(err,err.stack)
          }
        }
         function loadFile(event) {
         	 loadData('TEST_CASE_1',event);
         }
         function loadFile2(event) {
         	 loadData('TEST_PRODUCT_1',event);
         }
         function loadFile3(event) {
         	 loadData('TEST_PRODUCT_2',event);
         }
         function loadFile4(event) {
         	 loadData('TEST_COMPANY_1',event);
         }
         
         function loadData(table, event) {
             alasql('SELECT * FROM FILE(?,{headers:true})',[event],function(data){
            // Process data here
            	  alasql(`CREATE TABLE IF NOT EXISTS ${table}
                  (
                    id        varchar(128) NOT NULL,
                    name      varchar(512),
                    number    double precision,
                    data_ref  varchar(128),
                    data_refs...