>Hi,
>
>I have a query which access 13 tables and when I execute the query I get the progress bar stating running query and finally pops up an error message "can't create temp work files".
>
>Why would I get this error when I have sufficient disk space.
>
>Thanx
>Gnana.

You should break your SELECT up into smaller pieces. There is no way it will be optimized, and may even be slower than multiple SELECTs.