Same is true for Oracle 8i/9i/10g. E.
--- Rob Lohman <[EMAIL PROTECTED]> wrote: > Microsoft SQL seems to use the column names from the > first select. So that would be "a, b" in your example. > > Rob > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "Sqlite-users" <sqlite-users@sqlite.org> > Sent: Saturday, March 25, 2006 3:45 PM > Subject: [sqlite] Column names in a UNION > > > > 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]> > > > > > ---------- > * Zoner PhotoStudio 8 - Your Photos perfect, shared, organised! > www.zoner.com/zps > > __________________________ Stops spam 100% for your email accounts or you get paid. http://www.cashette.com
