title: SQL - How to avoid duplicates with LEFT JOIN when RIGHT table has multiple rows?
body: <p>I need to do a query on <code>Publications</code>, and also on <code>Authors</code> linked with <code>Publications</code>.</p>