title: Presenting Data uniformly between two different table presentations with SQL
body: <p>Hello Everyone I have a problem…
  Table 1 (sorted) is laid out like this:</p>
  <pre><code>User ID    Producer ID  Company Number
  JWROSE     23401        234
  KXPEAR     23903        239
  LMWEEM     27902        279
  KJMORS     18301        183
  </code></pre>
  <p>Table 2 (unsorted) looks like this:</p>
  <pre><code>Client Name       City           Company Number
  Rajat Smith       London         JWROSE
  Robert Singh      Cleveland      KXPEAR
  Alberto Johnson   New York City  LMWEEM
  Betty Lee         Dallas         KJMORS
  Chase Galvez      Houston        23401
  Hassan Jackson    Seattle        23903
  Tooti Fruity      Boise          27902
  Joe Trump         Tokyo          18301
  Donald Biden      Cairo          234
  Mike Harris       Rome           239
  Kamala Pence      Moscow         279
  Adolf Washington  Bangkok        183
  </code></pre>
  <p>Now… Table 1 has all of the User IDs and Producer IDs properly rowed with the Company Number.
  I want to pull all the data and correctly sorted….</p>
  <pre><code>Client Name           City           User ID    Producer ID   Company Number
  Rajat Smith           London         JWROSE     23401         234
  Robert Singh          Cleveland      KXPEAR     23903         239
  Alberto Johnson       New York City  LMWEEM     27902         279
  Betty Lee             Dallas         KJMORS     18301         183
  Chase Galvez          Houston        JWROSE     23401         234
  Hassan Jackson        Seattle        KXPEAR     23903         239
  Tooti Fruity          Boise          LMWEEM     27902         279
  Joe Trump             Tokyo          KJMORS     18301         183
  Donald Biden          Cairo          JWROSE     23401         234
  Mike Harris           Rome           KXPEAR     23903         239
  Kamala Pence          Moscow         LMWEEM     27902         279
  Adolf Washington      Bangkok        KJMORS     18301         183
  </code></pre>
  <p>Query:</p>
  <pre><code>Select
  b.client_name,
  b.city.,
  a.user_id,
  a.producer_id,
  a.company_number
  
  From Table 1 A
  Left Join Table 2 B On a.company….
  </code></pre>
  <p>And this is where I don’t know what do to….because both tables have all the same variables, but Company Number in Table 2 is mixed with User IDs and Producer IDs... however we know what company Number those ID's are associated to.</p>