>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.
>
Using DELETED() in the WHERE clause of an SQL statement is not dependable because the expression might not be evaluated against the table you expect, and may not be evaluated for every record. If you want your view/query to exclude deleted records, make sure that SET DELETED is ON when the view is opened/requeried.
Erik Moore
Clientelligence