CREATE TABLE a(val INTEGER);
CREATE TABLE b(val INTEGER);

SELECT * FROM a LEFT JOIN b ON a.val = b.val;