CODE EXAMPLE FOR SQL

LEFT JOIN

SELECT
	pka,
	c1,
	pkb,
	c2
FROM
	A
LEFT JOIN B ON pka = fka;
Code language: SQL (Structured Query Language) (sql)
/* https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-left-join/ */