Oracle reports: linked queries
From: Scot Balfour <scot.balfour_at_lmco.com>
Date: Wed, 09 Dec 1998 12:32:19 -0500
Message-ID: <366EB423.A27FF02A_at_lmco.com>
[Quoted] My team is trying to understand the differences between writing a single query that joins several tables versus and writing one query per table and linking them together.
Date: Wed, 09 Dec 1998 12:32:19 -0500
Message-ID: <366EB423.A27FF02A_at_lmco.com>
[Quoted] My team is trying to understand the differences between writing a single query that joins several tables versus and writing one query per table and linking them together.
It seems like when you link the independent queries: A and B, you can't select the order of the fields that appear in the default layout. We wanted a report that included fields: A1, A2, B3, A3, B4 but the default layout always took all of A's fields first, then all of Bs'. We could omit fields, but not resequence.
We concluded that if you needed to include fields from multiple tables and you wanted to order the default layout by alternating between fields from table A with table B, you needed to write a single query with a join, instead of linking independent queries.
Can anyone validate this conclusion or better explain their success/rationale behind linked queries? Thanks. Received on Wed Dec 09 1998 - 18:32:19 CET