Andrew Guts wrote:

>
> This "SELECT" returns 2 rows
>
> select CustomerID, Total from vByCustomer where CustomerID = 38500
> -------------------------------------------------------
> 38500 252.0000
> 38500 -504.0000
>
> "SELECT" part of the view "vByCustomer" contains 3 records for 38500:
> -------------------------------------------------------
> 38500 252.0000
> 38500 -504.0000
> 38500 252.0000
>

I didn't try to read and understand all your code, but maybe there is a
clue in the UNION clause - it eliminates duplicates. Will UNION ALL help any?

[No idea about the crashing, though]


Regards,
Aage J.