title: SQL - Join two tables but only show specific value
body: <p><br>
  Alright so I've created a database called news which contains few tables with different information in them. I have two table's one named <strong>Employee</strong>'s and the other table is called <strong>Article</strong>'s. <br><br>
  Now what I would like to receive from Employee tabel is Name(The names of the Employee's) and Title. And from the Article table I would like it to show what type of Article every Employee has been on and writen since they are connected through the ArticleID. But I would only like for a specific ArticleID to show for example numer 2. Here is an example of the output I would like to show. <br><br></p>
  
  <pre><code>                   Titel         Name            ArticleID   
                     Redirector    Jonas              2
                     journalist    Clark              2
                     journalist    Louise             2      
  </code></pre>
  
  <p><br><br></p>
  
  <p>This is how far I've goten with my SQL code but  I cant get it to work, they error i'm getting says that p.Employee does not exsist.  </p>
  
  <pre><code> SELECT p.Titel, p.Name, ap.ArticleID
      FROM Employee p join
           Article ap
           on p.Employee  = ap.Article
      WHERE ap.ArticleID IN (2);
  </code></pre>
  
  <p>Some help on this would be appreciated.</p>
  
  <p>Edit -----------------
  How the table structure looks. I apologize for the inconvenience caused.</p>
  
  <p>Table Employee</p>
  
  <pre><code>EmployeeID  Name    UserName    Pass      Titel         PhoneNumer 
      1       Clark    xxxxxx      a      journalist       12356465
      2       Louise   aaaaaa      b      journalist       45648984
      3       Jonas    bbbbbb      c      Redirector       489489448
  </code></pre>
  
  <p>Table Article</p>
  
  <pre><code> ArticleID      KategoriID       preamble    Body   headlines         Published
      1              1             dwadwad
      2              2              qweqw
      3              3              dwqdqw
  </code></pre>