title: UniVerse TCL line JOIN syntax
body: <p>I am trying to JOIN two tables; PRODUCT AND PSUB. </p>
  
  <p>PRODUCT contains one row of data for each PRODUCT_ID</p>
  
  <p>PSUB contains multiple rows of data for each PRODUCT_ID transaction, however PRODUCT_ID is not multivalued. </p>
  
  <p>Here is the output of both tables on two specific IDs.</p>
  
  <p><img src="https://i.stack.imgur.com/rXnlK.png" alt="enter image description here"></p>
  
  <p>I would like to JOIN the tables, to run two reports:</p>
  
  <ol>
  <li><p>Show PRODUCT_IDS that are in PRODUCT table, however, exclude those that are in PSUB table. </p></li>
  <li><p>Show all PRODUCT_IDs that are in PSUB table, however, exclude those that are in PRODUCT table.</p></li>
  </ol>
  
  <p>Here is what I attempted to use to get a COUNT, however, query basically locked up:</p>
  
  <p>SELECT COUNT (*) FROM PRODUCT, PSUB WHERE PRODUCT.PRODUCT_ID &lt;> PSUB.PRODUCT_ID;  </p>
  
  <p>Here are the individual COUNT queries.</p>
  
  <p><img src="https://i.stack.imgur.com/534X6.png" alt="enter image description here">        </p>
  
  <p>Thank you for your help in advance!!</p>
  
  <p>Tom</p>