I am using Access database and C#.
I have a union of 3 tables for calculating some balance and I need to get the running sum of that balance, but I can't use partition over, because I must do it with the sql query that is gonna work in Access. My problem is that I cannot use join on a alias...