Re: Reports 6i: showing data from another query

Hello Noah
you wrote
> So, for example, if Query A had
>
> select name
> , address
> from customer_details
>
> ... could you do something like this...
>
> select :name
> , "other_stuff"
> from...
>
> ... in Query B?
No.
You could try something else, though.

You said you have a parent-child query. I assume that means 'master-detail'. And you have a link.
[Quoted] You can rewrite the query's A and B to one query: Lets assume the link is made with the column cd_id in the table 'other_table' from your previous query B

select cd.id

  ,       cd.name
  ,       cd.address
  ,       cd.address
  ,       ot.cd_id
  ,       ot.column_one
  ,       ot.column_two
  from customer_details cd
  ,       other_table          ot

I've select the column 'adress' from table customer_details twice. If you make a group in your report with the colum cd.name and the first cd.adress column, then the second column cd.adress can appear in every record from table 'other_table' and you would have achieved your goal.

Good luck, Joost Received on Fri Oct 05 2001 - 12:45:24 CEST