>>Could it be that there are records just without a Report name in the Reports file?
>
>Yes, they could, but then that is redundant:
>reports.rptname != NULL; *Should make sure there is a report listed

Actually, you're absolutely right with your first suggestion. I just re-checked the query, it uses WHERE conditions on the Reports table, so it should be an INNER JOIN.

And when you can check for the

NOT Reports.RptName =='' and  Reports.RptName NOT NULL

or

not NVL(Reports.RptName),"") == ""