CREATE table a (id int,f int);
CREATE table b (id int,f int);

INSERT INTO a (id, f) VALUES (1,1);
INSERT INTO a (id, f) VALUES (2,1);
INSERT INTO a (id, f) VALUES (3,2);
INSERT INTO a (id, f) VALUES (4,3);
INSERT INTO a (id, f) VALUES (5,3);

INSERT INTO b (id, f) VALUES (1,1);
INSERT INTO b (id, f) VALUES (2,1);
INSERT INTO b (id, f) VALUES (3,2);
INSERT INTO b (id, f) VALUES (4,3);
INSERT INTO b (id, f) VALUES (5,7);




SELECT * FROM a
SELECT * FROM b

SELECT a.id, a.f, b.id, b.f 
FROM a
JOIN b ON a.id=b.f

SELECT a.id, a.f, b.id, b.f 
FROM a
INNER JOIN b ON a.id=b.f

SELECT a.id, a.f, b.id, b.f 
FROM a
LEFT OUTER JOIN b ON a.id=b.f

SELECT a.id, a.f, b.id, b.f 
FROM a
LEFT JOIN b ON a.id=b.f

SELECT a.id, a.f, b.id, b.f 
FROM a
RIGHT OUTER JOIN b ON a.id=b.f

SELECT a.id, a.f, b.id, b.f 
FROM a
RIGHT JOIN b ON a.id=b.f


SELECT a.id, a.f, b.id, b.f 
FROM a
FULL OUTER JOIN b ON a.id=b.f