Hi
Im developing a report with data report and i have a question:
The follow query return me 10 records:
The results from this query is used in the follow query: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 result of this query is used in report.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
This 2 querys are from different databases. How can i generate a report with data report to show this report?
Thanks
Daniel




Reply With Quote