>>It's not really a bug, and the behavior isn't just in views.
>
>So this "behavior" is an SQL thing? I just dont get why it would not maintain the
>result record in its original "deleted" state?
My off-the-cuff guess would be that it has to do with the fact that very few databases support a deleted flag -- in SQL Server, for example, once you delete a record, it's gone. So, the expectation would be that if it's in the table, it's available.
This is hardly a satisfactory explanation, but without knowing for sure, it's my best guess.