title: SQL: Showing columns from 2 tables
body: <p>I have a resource and an orders table in my SQL Database and I have the following SQL query:</p>
  
  <pre><code>Select resource.id, resource.name from resource
  inner join orders on orders.res_id = resource.id 
  where orders.markup &lt; 1000 and 
  resource.id = 100
  </code></pre>
  
  <p>This works fine and shows the filtered ID and NAME field in my view. However, I would also like to see the orders.markup column in the view. I tried the following:</p>
  
  <pre><code>Select resource.id, resource.name, orders.* from resource, orders 
  inner join orders on orders.res_id = resource.id 
  where orders.markup &lt; 1000 and 
  resource.id = 100
  </code></pre>
  
  <p>This fails with: </p>
  
  <pre><code>ORA-00904: "RESOURCE"."ID": invalid identifier
  </code></pre>