Join

SELECT JOIN

    alasql('SELECT * FROM Cities JOIN Countries');

JOIN ON

    alasql('SELECT * FROM Cities JOIN Countries ON Citites.Country = Countries.Country');

JOIN USING

    alasql('SELECT * FROM Cities JOIN Countries USING Country');