I would like to use UNION to amalgamate two result sets, but I need to excuse some columns (the same columns in each set) from the matching requirement. The unmatched columns are the same data type, but not the same data.
Is this possible, and if so, any clues?
Thanks for any ideas
Mike