Who can tell me what the "correct" column names should be for a UNION. For example:
SELECT a, b FROM t1 UNION SELECT x, y FROM t2; The result set of the query above has two columns. Should those columns be named a and b or x and y? Does anybody know what the SQL standard says? Do all the other SQL database engines get it right or is there some disagreement? -- D. Richard Hipp <[EMAIL PROTECTED]>