Re: Complex Querys using instances of tables

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks again!
And its all working. Btw the access 2003, uses the simple sintax:
<query|table|subquery> AS <instancename> to create instances or to name
subquerys.

So first version in Oracle comes:
SELECT DISTINCT rh.report_name, rh.user_name, rh.report_run_date
FROM report_history AS rh, [SELECT report_name, max(report_run_date) as
maxdate FROM report_history GROUP BY report_name]. AS maxresults
WHERE rh.report_name=maxresults.report_name And
rh.report_run_date=maxresults.maxdate;

.