Re: SQL Syntax: SELECT ... UNION

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: chora <choracyAThotmail.com>
Date: Mon, 07 Jan 2008 22:53:09 -0800

I suppose a.column is the same with b.column right? I believ you cannot
have a different sort column in a union, because there is a single
result set. I cannot test it right now, but I believe the ORDER BY can
exist in only one of the queries. The sorting will affect the entire
set.

*** Sent via Developersdex http://www.developersdex.com ***
.

References:
- SQL Syntax: SELECT ... UNION
  - From: Michael Hanke

Prev by Date: Sqlserverce class not working when VB.Net application is running from network drive
Next by Date: Re: Sqlserverce class not working when VB.Net application is running from network drive
Previous by thread: SQL Syntax: SELECT ... UNION
Next by thread: Re: A Sql Compact problem
Index(es):
- Date
- Thread