title: How do I compare the results of two queries, and find matches between the two?
body: <p>First of all, I'm not sure if this should be done in Coldfusion or MySQL. </p>
  
  <p>I have a query of items that retrieves items in a catalog. I have a second query that retrieves items from a user's list. My objective is to find out if an item is already present in a user's list when outputting the first query (the items catalog). </p>
  
  <pre><code>items(itemId, itemName)
  
  users_items(itemId,memberId)
  </code></pre>