title: SQL Query for finding specific row in posgresql server
body: <p>I have two tables <a href="https://i.stack.imgur.com/jzpeI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jzpeI.png" alt="tables"></a> respectively <code>department_location</code> and <code>project</code></p>
  
  <p>I would like to find any projects running at a different location than the department location.</p>
  
  <p>The resulting should be like this:<a href="https://i.stack.imgur.com/BS8PG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BS8PG.png" alt="like this"></a></p>
  
  <p>The code that I've implemented :</p>
  
  <pre><code>SELECT pro.pnumber,pro.pname,pro.plocation,dept.dlocation
  FROM project AS pro,dept_location AS dept
  WHERE pro.plocation != dept.dlocation AND pro.dnum = dept.dnumber
  GROUP BY pro.pnumber,dept.dlocation
  </code></pre>
  
  <p>What am I missing?</p>
  
  <p>Edit: Here is my<a href="https://gofile.io/?c=icR4qG" rel="nofollow noreferrer">.sql file</a></p>