Re: Using ORDER BY in a UNION
From: SPillay190 <spillay190_at_aol.com>
Date: 9 Mar 1999 01:14:07 GMT
Message-ID: <19990308201407.03978.00000157_at_ng34.aol.com>
Date: 9 Mar 1999 01:14:07 GMT
Message-ID: <19990308201407.03978.00000157_at_ng34.aol.com>
Hi,
When using the Order by with a union,
you cannot use the column name, but you can
use Order by 1,2,3
e.g Select A, B from X
union Select C,D from X
order by 1
Received on Tue Mar 09 1999 - 02:14:07 CET