UNION but with excused columns

[Mike Rowan]

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

[David Rowley]

Post by Mike Rowan
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?

Yes, just use a sub-query: e.g: SELECT a,b,c FROM (SELECT a,b,c,d FROM
t1 UNION SELECT a,b,c,d FROM t2) t;