Hi all,

I have a view which uses LEFT OUTER JOINS to join several tables, the problem is, records that are deleted in some of the tables are being pulled into the resultant view, creating records that shouldn't be there, even though I have a "NOT DELETED()" in my WHERE clause.

I've tried adding "WHERE NOT DELETED()" to each JOIN, but that didn't work either. Am I doing something wrong?
If I try adding the alias to the DELETED() command I just get Column/Field not found messages.

Please enlighten me.

Thanks,

- Aaron.