title: Overlap of unique Identifiers when trying to pull/expand data
body: <pre><code>LoadTableQuery.Qry = @"
  SELECT `orders`.`ordID`,
      `orders`.`OrderType`,
      `prt`.`Name`,
      `orders`.`prtID`,
      `orders`.`ReqRef`,
      `orders`.`DateOrdered`,
      `orders`.`orderETA`,
      `orders`.`DateRcvd`,
      `orders`.`Status`,
      `orders`.`ShipCost`,
      `orders`.`Duties`,
      `orders`.`Currency`,
      `orders`.`Conv`,
      `orders`.`Terms`,
      `orders`.`Shipping`,
      `orders`.`BuyerID`,
      `orders`.`ShipTo`,
      `orders`.`Notes2`,
      `orders`.`Notes3`,
      `orders`.`legacyID`,
      `prt`.`Address`,
      `prt`.`City`,
      `prt`.`StateProv`,
      `prt`.`PostalZip`,
      `prt`.`Tel`,
      `prt`.`Contact`,
      `prt`.`Email`,
      `prt`.`OrderTaxPc`
  FROM `n2000`.`orders` left join `n2000`.`prt`
  on (orders.prtID = prt.prtID)
  </code></pre>
  
  <p><code>prtID</code> is a unique identifier which I'm using to pull the data I need about the party (their name, address, city..). The way it's written above works, accomplishing what I need it to do. getting and inserting the data into my table. </p>
  
  <p>The issue is, I need a SECOND set of party data, based on <code>orders</code>.<code>ShipTo</code> instead of <code>orders</code>.<code>prtID</code> . ShipTo is really just a different prtID. </p>
  
  <p>I'd like to be able to just run it again with </p>
  
  <pre><code>on (orders.ShipTo = prt.prtID).
  </code></pre>
  
  <p>I've tried using UNION, but that creates a new row, instead of adding columns to my current row. Which is where I'm looking to pull my data from.</p>
  
  <p>The best way to understand it is, I've expanded prtID to add the Name, Address, City.. column data. I'd like to expand ShipTo as well. I don't know how to do that though without simply overwriting the prtID expansion.</p>
  
  <hr>
  
  <p>The solution was actually quite simple. Hope this helps someone else</p>
  
  <p><a href="https://i.stack.imgur.com/jGw9o.png" rel="nofollow noreferrer">Solution</a></p>