title: Problem accessing specific column using INNER JOIN
body: <p>I have two tables <code>Listings</code> &amp; <code>Reviews</code> that both have a column <code>id</code>.</p>
  
  <p>I want to <code>inner join</code> them with <code>Listings.id = Reviews.listing_id</code> but when I am specifying something in my <code>pgadmin</code>, like <code>listings.id</code> or <code>example.example</code> it seems like it doesn't recognise it. </p>
  
  <p>I get the error:</p>
  
  <blockquote>
    <p>missing FROM-clause entry for table "listings"</p>
  </blockquote>
  
  <p>Do I write something wrong?
  Here is the code:</p>
  
  <pre><code>SELECT 
    id, listing_url, reviewer_id, reviewer 
  FROM 
    public."Listings" 
    INNER JOIN public."Reviews" ON Listings.id = listing_id 
  WHERE 
    reviewer = 'Vivek' 
  order by 
    reviewer_id;
  </code></pre>