Data report question

[Jupiter-SL9]

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

The follow query return me 10 records:

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:

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

[Hack]

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.

[Jupiter-SL9]

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

thanks