Re: Reports 6i: showing data from another query
From: Noah Arc <bowed_zombie_drone.spam.begone_at_zombie.co.uk>
Date: Fri, 5 Oct 2001 13:24:43 +0100
Message-ID: <gEhv7.34958$uM2.5107456_at_monolith.news.easynet.net>
Date: Fri, 5 Oct 2001 13:24:43 +0100
Message-ID: <gEhv7.34958$uM2.5107456_at_monolith.news.easynet.net>
Thanks - muchly appreciated.
-- Noah Arc Remove ".spam.begone" Joost Bataille <j.r.l.m.bataille_at_uva.nl> wrote in message news:9pk305$quk$1_at_mail.ic.uva.nl...Received on Fri Oct 05 2001 - 14:24:43 CEST
> 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.
> 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
> where cd.id = ot.cd_id
>
> 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
>
>
>
>
>
>
>