Hi Fred, group,
I wrote--
>I'm trying to get just a total of the funds amount for a
> Job, Sub and Task like this --
> SELECT Jobs.Job, Jobs.Sub, Jobs.Task, sum(Funds_Recd.Amt) AS Amount
> FROM Jobs, Funds_Recd WHERE Jobs.Job=Funds_Recd.Job and
> Jobs.Sub=Funds_Recd.Sub and Jobs.Task=Funds_Recd
On Fri, Jun 27, 2003 at 09:05:48AM -0400, Moulder, Glen wrote:
> G'day all,
>
> Having trouble with SUM, could use a hand. I inherited a table, Funds_Recd that
> looks like this:
>
> ID Job Sub Task Amt
> 1A01 A1910,001.00
> 102 B53 A201 79.47
> 213 X99 L8838
G'day all,
Having trouble with SUM, could use a hand. I inherited a table, Funds_Recd that looks
like this:
ID Job Sub Task Amt
1A01 A1910,001.00
102 B53 A201 79.47
213 X99 L8838,289.02
284 A01 A19126.98
I do not have ownership and *MAY NOT* change
