> Only the first SELECT is used to define column types and names (in the case of NULL AS source2_* I am not positive if you need to cast the NULL or if it will use the type found in the second SELECT) and I generally put a "source" field into the output with a textual representation of which table the record originated from.
>
Seems like it would be more efficient just to create a table (temp or
otherwise) with and pump data into that.
Anyway thanks for the help.