title: Select statement with result even if there isn't in the db
body: <p>I have this table with all my attachment on specific customer order and I want to select only one kind of attachement, but I want to see the line even if there is no attachment. Is there a way to do so?</p>
  
  <p>I tried this but it doesn't work:</p>
  
  <pre><code>SELECT 
    Comm.No_Com, 
      CASE WHEN Attachement.EntityID IS NULL OR Attachement.ATS_CategoryOfAttachmentCode='DESSIN'
          THEN Attachement.FileName
          ELSE ' '
      END AS Dessin
  
      FROM Comm
      INNER JOIN Attachement
      ON Comm.COH_Id=Attachement.EntityID
  </code></pre>