Queries in SQL*ReportWriter
From: Mike Smiljanic <msmiljan_at_seldon.apanix.apana.org.au>
Date: 29 Aug 1994 07:09:48 GMT
Message-ID: <33s1js$qvo_at_cleese.apana.org.au>
Date: 29 Aug 1994 07:09:48 GMT
Message-ID: <33s1js$qvo_at_cleese.apana.org.au>
Subject: Queries in SQL*ReportWriter
Newsgroups: comp.databases.oracle
Summary:
Keywords:
X-Newsreader: TIN [version 1.2 PL2]
I'm new to using SQL*ReportWriter. Could someone please tell me if it is possible to use a UNION clause in a child query. Every time I attempt to do so I get an error advising me that my query is improperly ended.
Basically what I'm trying to do is
SELECT x,y,z from table1
UNION
SELECT x,y,z from table2
any help would be appreciated.
Mike Smiljanic Adelaide,Australia
msmiljan_at_apanix.apana.org.au
Received on Mon Aug 29 1994 - 09:09:48 CEST