[sqlite] How to remove duplicate records

[Clemens Ladisch]

Dominique Devienne wrote:
>Always ran into Error: only a single result allowed for a SELECT that
>is part of an expression. --DD

In a join, you can directly use a subquery with multiple columns:
... JOIN (SELECT ...) ...


Regards,
Clemens