>>>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,"") == ""

You can have Report Id but have NULL in Report Name?
BAD!
:o)