Skip to content
Andrey Gershun edited this page May 25, 2015 · 4 revisions

USING

In AlaSQL you can use USING clause like in this example:

    CREATE TABLE one (a INT, b INT);
    INSERT INTO one VALUES (1,10),(2,20);
    CREATE TABLE two (a INT, c INT);
    INSERT INTO two VALUES (1,100),(2,200);
    SELECT one.a, b, c FROM one JOIN two USING a;
Clone this wiki locally