title: SQL query two tables with 2 same value
body: <p>I have two tables: <code>item</code> table and <code>detail</code> table.</p>
  
  <p>In the <code>item</code> table I have snum, itemname, description
  In the detail I have tnxid, snum, status</p>
  
  <p>What I want to do is output tnxid, snum, itemname, description, status</p>
  
  <p>My problem: how will input all of those that the values along the snum in item table and snum in detail table union together. (both snum must have the same values)</p>