title: How can I create a new table based on merging 2 tables without joining certain values?
body: <p>I asked a question earlier, but I wasn't really able to explain myself clearly.</p>
  
  <p>I made a graphic to hopefully help explain what I'm trying to do.</p>
  
  <p><img src="https://i.stack.imgur.com/o8w4s.png" alt="enter image description here"></p>
  
  <p>I have two separate tables inside the same database. One table called 'Consumers' with about <strong>200 fields</strong> including one called 'METER_NUMBERS*'. And then one other table called 'Customer_Info' with about 30 fields including one called 'Meter'. These two meter fields are what the join or whatever method would be based on. The problem is that not all the meter numbers in the two tables match and some are NULL values and some are a value of 0 in both tables.</p>
  
  <p>I want to join the information for the records that have matching meter numbers between the two tables, but also keep the NULL and 0 values as their own records. There are NULL and 0 values in both tables but I don't want them to join together.</p>
  
  <p>There are also a few duplicate field names, like Location shown in the graphic. If it's easier to fix these duplicate field names manually I can do that, but it'd be cool to be able to do it programmatically.</p>
  
  <p><strong>The key is that I need the result in a NEW table!</strong></p>
  
  <p>This process will be a one time thing, not something I would do often.</p>
  
  <p>Hopefully, I explained this clearly and if anyone can help me out that'd be awesome!</p>
  
  <p>If any more information is needed, please let me know.</p>
  
  <p>Thanks.</p>