We just upgraded our service software \ database.  The location of one of our fields changed during this process.  Any new order will place data in this new field.  Any existing orders will still have data in the old field.  The two fields are located in two different tables.  I'm trying to bring the data into a report regardless of where it resides, old or new.  Only one of these fields will have data in it based on when the order was created, before or after the transition.  Any ideas?  Appreciate it.