CODE EXAMPLE FOR SQL

postgres left join

SELECT	pka, c1, pkb, c2
FROM	A
LEFT JOIN B ON pka = fka