I've been in an argument with one of our devs that took an update statement with an inner join and made it a left join (because inner was missing some records somehow in the left table - tableB in ...
</pre><BR><BR><BR>So, if I wanted a report on the total amount a user has spent, I would add the initial and subsequent expenditures and subtract the credits. So, Bob would have a total of $100.00 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results