Combining Data

I need to combine ESRI SDE point data from 2 different tables.  I would like to create a union, an SQL union not spatial, to do this.  I need header information from one table to propogate forward for the writer that I am using, which is from GE FieldSmart.  Any ideas how to do this?

 

 

Thanks