You're generating a huge result set - possibly that infamous 'Cartesian Result'. I would DEFINITELY break it up into several SELECTs, and take a moment to check the result every step of the way to make sure you're getting the results you want.
>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.
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site