I am banging my head against my desk trying to figure this out!!!
I have 5 tables. Each has a similar ID to go off of and a similar column that contains a 'money' field called Total...
I am trying to get the sum for these totals..
All I want is all of them added together.
Some tables will contain more than one column (With the same ID) and some may be NULL.
All I need is a SELECT case that returns ONE Row and One Column with All the totals added up.
The query I need would return 30