title: Comparing 2 items but using a value from found item
body: <p>Having some issues trying to figure out how to write a SQL line to grab a value from an item. Let me explain the situation. We have 2 different databases, one for domestic and one for import. They're the same items just different product codes. The difference is just the international items have a -h at the end. So example..</p>
  
  <pre><code>12345   &lt; domestic 
  12345-h &lt; import
  </code></pre>
  
  <p>We have a feed going which combines both together but the import items are missing upc codes, while the domestic items have them. So what I wanted to do was have it match both product codes and add the upc to the -h item.</p>
  
  <p>Any ideas?</p>