Multi query report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, need some help.
How do I make a report acept multi query results.
I want a report that retrives results from several queries.
How can I make this happen?
Thanks for the help.
 
U can use Subqueries.
Like this ..


SELECT DISTINCT
(SELECT ... FROM TableX
WHERE .... ) AS Expression1,

(SELECT .... FROM TableY
WHERE ...) AS Expression2,

FROM TableX, TableY;

So you get a Table from the result of more than one query.

Martin
 
It depends on how your data should be presented. You may join the queries
if the queries that contain data that belongs on the same "row". You may
union the queries if they represent lists of records that should be
presented one after the other. Or, they may be hierarchically related and
your best solution will be to use a report for the "parent" and subreports
for each "child".
 
Back
Top