I fixed it!, it just added an index!
Thanks anyway...
"Ligia M. Pimentel" <lmpc(at)nettaxi(dot)com> wrote in message
news:944kbb$114p$1(at)news(dot)tht(dot)net(dot)(dot)(dot)
> I have a database and a table with 70000 records (which i dont think it's
> too much)
> I join this table with another of about the same size and put a record
> restriction (WHERE) and everything works out fine, but when I put two SUMs
> over a couple of fields and add a GROUP BY I keep getting this error,
>
> ltsWriteBlock: failed to write block 27231 of temporary file
> Perhaps out of disk space?
>
> I checked and I have over 1GB free so I figure this must have something to
> do with configuration parameters.
>
> I'd appreciate any help.
>
>
> Ligia
>
>