title: Netezza - relation does not exist on SQL select
body: <p>I can't understand why this query wont work, I'm using Netezza DB, new to that. If I remove these two lines:</p>
  
  <pre><code>  inner join table_two tb2 
    on tb2.ID = tb1.ID
  </code></pre>
  
  <p>the select works, but it isn't the right result, why is it failing when I use the "inner join" lines? Aynone, please. Thank you!</p>
  
  <pre><code> select  count(t1.FIRSTNAME)
   from  table_one tb1
   inner join table_two tb2 
   on tb2.ID = tb1.ID
   where UPPER(tb1.FIRSTNAME) LIKE 'JOE%' AND UPPER(tb1.LASTNAME) LIKE '%DOE%'
  </code></pre>