Re: Unions in SQR

[Manoj Gurjar <mgurjar@HOTMAIL.COM>]

Hi David,

It works like this :

In SQR, Select with UNION works differently.
It still has same std rules as RDBMS Union, like the SELECT field
list for the secondary SQL-select statement in the Union query must
match the data type, number of columns, and length of columns
selected in the first SQL-select.
Enter the part of the SQL-Select statement that follows the Union clause as
normal select statement we type in say SQL*Plus,
I mean with commas between column names and without alias
names. We can not have any SQR statements after selected fields and before
FROM in this second Select(Select after Union).

So whatever fields you want to print, do that in first
select statement. You can do additional processing in First
select but not in second.

Hope I made clear enough.

Give me your select statements, I will send you one with
UNION.

HTH,
Manoj

>From: David Fordham <dfordham@SUMMITTECH.COM>
>Reply-To: SQR-USERS@list.iex.net
>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>Subject: Unions in SQR
>Date: Wed, 3 Nov 1999 12:40:42 -0700
>
>Hi all,
>
>Anyone ever have eny luck doing an Oracle union in an SQR??   I have tried
>all day to get this to work but to no avail.
>
>TIA,
>
>David Fordham
>
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>          S U M M I T   T E C H N O L O G I E S,  I N C.
>
>http://www.summittech.com             dfordham@summittech.com
>8921 E Chenango Ave                   303.740.8791
>Greenwood Village, CO  80111          888.833.7360  Toll Free
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com