I ENTER THIS CODE INTO MYSQL SERVER TO 'Write an SQL that will display authors and their publications even authors that have no publications ' : 
        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
AND GET THE ERROR
        Msg 102, Level 15, State 1, Line 8
        Incorrect syntax near ';'.
