title: Trying to write a query that will display authors and their publications even authors that have no publications
body: <pre><code>    SELECT a.auth_name AS 'NAME', p.pub_title AS 'PUBLICATION'
      FROM publication p
      LEFT OUTER JOIN author_publication d
      ON p.pub_id = d.pub_id
      LEFT OUTER JOIN(
      SELECT a.auth_name 
      FROM author a,author_publication d
      WHERE a.auth_id = d.auth_id);
      GO
  </code></pre>
  
  <p>AND GET THE ERROR
          Msg 102, Level 15, State 1, Line 8
          Incorrect syntax near ';'.</p>