Re: RE:RE: Question of Reports 3.0

From: NT Entwicklung <gle_at_rts.co.at>
Date: Tue, 18 Aug 1998 15:33:13 +0200
Message-ID: <903447124.446033_at_news.vbs.at>


The best I think ist to make a query with this queries e.g.
select a.x,b.y
from
(select x from tab1) a,
(select y from tab2) b
where a.x > b.y

Roberto Lorente Alvarez schrieb in Nachricht <6rbun6$kkt$1_at_diana.bcn.ibernet.es>...
>you didn't understand me.
>
>I have a report with two independient querys q_1 and q_2, like two
distinct
>reports.
>The problem is: In the query 1 i calculate totals and i want to use some
>totals of the query 1 in the query 2.
>I want to do a select of the query1 (report 1) to use some results in the
>query 2.
>thanks.
> Roberto
>
>
>Have you tried creating a group? Or would that give you too many rows?
>Roberto Lorente Alvarez wrote in message
><6qbqtf$skv$1_at_diana.bcn.ibernet.es>...
>>I have a report with two queris, q_1 and q_2
>>The query Q_1 is a report and the q_2 is another report.
>>I want to take fields from de Q_1 to the Q_2.
>>
>>for example:
>> the Q1 calculates the summary of the column Salary ,named sumsal,
groub
>>by Month and by Dept.
>> On the second query i want to do something like this:
>>
>>select :sumsal from :Q_1 where .....
>>
>>the question is ?
>>
>>Can i select fields or columns from the query Q_1 to the query Q_2?
>>
>>thanks for read the message.
>>
>>
>>
>>The second query takes
>>
>>
>
>
>
Received on Tue Aug 18 1998 - 15:33:13 CEST

Original text of this message