CI4 JOIN gives duplicate (and more) results

Managed to solve the problem with some help elsewhere. I removed the from line and changes ->table to:
$builder = $db->table('eenheden as e');

Not is works as expected.

Sometimes one works on a problem so long (specially when new to a framework, as I am to CI in general) that you read over the solution. It was right there in the documentation. I hope someone else can learn from my mistake ;-)