Alasql joins

Alasql joins

by bilbobaggins

HTML

<script src="https://cdnjs.cloudflare.com/ajax/libs/alasql/0.4.5/alasql.min.js"></script>
<span id="res"></span>

JavaScript

var hotels = [
        { id: 101, Name: "Hotel 101", WebFacilities: [8, 9, 10] },
        { id: 102, Name: "Hotel 102", WebFacilities: [11] },
        { id: 103, Name: "Hotel 103", WebFacilities: [8, 10] }
    ];

    var facilities = [
        { id: 8, Name: "Facility 8" },
        { id: 9, Name: "Facility 9" },
        { id: 10, Name: "Facility 10" }
    ];

    var res = alasql('SELECT id, FIRST(Name) AS Name, COUNT(*) AS [Count] FROM ? facilities LEFT JOIN ? hotels ON facilities.id IN hotels.WebFacilities GROUP BY id', [facilities,hotels]);


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