>Thanks Naomi. I believe this one has solved my problem (I'll have to analyze it a little more closely to make sure everything is accurate, but there aren't any blank entries of rptname). I am not familiar with NVL so I'll have to look into it a bit, but it seems to have worked.
>
>Sergey's seemed like a good idea as well, but it gave me the same output as though I hadn't put in that condition at all for some reason.
>
>Thanks everybody for your quick responses.

Ron,

Don't use LEFT JOIN, use INNER JOIN. If you want to use LEFT JOIN, then you need to move all conditions involving Reports table into the JOIN and not into the WHERE clause.

If you have NULLs or BLANK values in the Report Name (I think you should not, may be you just need to fix the table), then use not NVL(Reports.RptName,"") == "" to check for both NULL and EMPTY().

So, I believe Borislav was spot on with his suggestion.