JSFiddle - React, Tailwind, and code Playground

by Andrey Gershun

HTML

<script src="http://alasql.org/console/alasql.min.js"></script>
<p>SELECT COLUMN extend(arr1_, arr2._)<span id="res1"></span></p>
    <p>SELECT arr1.*, arr2.*  <span id="res2"></span></p>
    <p>SELECT * <span id="res3"></span></p>

JavaScript

var arr1 = [{
    id: 1,
    name: 'fred',
    title: 'boss'
},{
    id: 2,
    name: 'jim',
    title: 'nobody'
},{
    id: 3,
    name: 'bob',
    title: 'dancer'
}];

var arr2 = [{
    id: 1,
    wage: '300',
    rate: 'day'
},{
    id: 2,
    wage: '10',
    rate: 'hour'
},{
    id: 3,
    wage: '500',
    rate: 'week'
}];

alasql.fn.extend = alasql.utils.extend;
var res1 = alasql('SELECT COLUMN extend(arr1._,arr2._) FROM ? arr1 JOIN ? arr2 USING id', [arr1,arr2]);

var res2 = alasql('SELECT arr1.*,arr2.* FROM ? arr1 \
                     JOIN ? arr2 USING id', [arr1,arr2]);

var res3 = alasql('SELECT * FROM ? arr1 \
                     JOIN ? arr2 USING id', [arr1,arr2]);

document.getElementById("res1").textContent = JSON.stringify(res2);

document.getElementById("res2").textContent = JSON.stringify(res2);

document.getElementById("res3").textContent = JSON.stringify(res3);