Larry wrote:
My $.02. As I agree SCSI has had a reputation for being
a more solid enterprise type drive, everyone's mileage varies.
We have moved to using all SATA drives in our newer servers. I
have to admit most of our databases are smaller than what many
on this list have. All our db's a
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
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
