Data report question

Hi
Im developing a report with data report and i have a question:

The follow query return me 10 records:

Code:

---

SELECT  ip.NR_LOCZ_EQPTO
FROM    INSPECAO_PALM ip
WHERE  ip.AL                    =        'INE01'
AND    ip.TIPO_REDE          =    'P'
AND    ip.DATA                  >=  TO_DATE('05/05/2005', 'dd/mm/yyyy')
AND    ip.DATA                  <=  TO_DATE('15/05/2005', 'dd/mm/yyyy')

---

The results from this query is used in the follow query:

Code:

---

SELECT  p.NR_LOCZ_EQPTO_RD, g.FEAT_CODE
FROM    G_MASTER g, PRI_BANCO_CAPCT_RD  p
WHERE  g.FEAT_NUM        =        p.FEAT_NUM
AND    p.NR_LOCZ_EQPTO_RD =        result

---

The result of this query is used in report.

This 2 querys are from different databases. How can i generate a report with data report to show this report?

Thanks
Daniel

If you are using VB as a front end, you can create two separate recordsets from those queries, and use them to populate your report.

Hi
But if the report has only one data source, how can i populate my report with 2 recordsets?

thanks