title: SELECT from table based on COUNT in SQL
body: <p>I have four tables:</p>
  
  <pre><code>  PAINTING            GALLERY             ARTIST              PAINTED
  - PAINTING_TITLE    - GALLERY_ID        - ARTIST_ID         - PAINTED_CODE
  - PAINTING_ID       - GALLERY_NAME      - ARTIST_LAST       - ARTIST_ID
                                          - ARTIST_FIRST      - PAINTING_ID
  </code></pre>
  
  <p>The PAINTED table keeps track of the painting painted by each artist. Some paintings are painted by more than one artist. I want to return a list of the paintings that have been painted by two artists.</p>
  
  <pre><code>SELECT
      PAINTING.PAINTING_TITLE AS TITLE, 
      GALLERY.GALLERY_NAME AS GALLERY
  FROM
      PAINTING,
      GALLERY,
      PAINTED
  WHERE
          PAINTING.GALLERY_ID = GALLERY.GALLERY_ID
      AND
          PAINTING.PAINTING_ID = PAINTED.PAINTING_ID
  GROUP BY
      PAINTING.PAINTING_TITLE,
      GALLERY.GALLERY_NAME
  HAVING
      COUNT(PAINTED.ARTIST_ID) = 2
  </code></pre>
  
  <p>This works, but it does not have the artist's name included in the results. I need the each artist's name to be listed along the gallery name and artwork name, each of which will appear twice, but once with a different artist.</p>
  
  <p>I'm using Access SQL.</p>