I have a conceptual question about how to quickly implement the equivalent of the following SQL query with LGP:

INSERT INTO tableA
SELECT *
FROM tableB
WHERE tableB.id NOT IN (
    SELECT id
    FROM tableA
)

A short hint how such a concept is called in LGP, or where to find an example/documentation about this would be enough. I hope

LLBLGen does not nativley support this constuct. You could wrap your required behaviour in a stored procedure, and call this using an LLBLGen Action Stored Procedure Call.

Matt