>I'd break it down into multiple SELECTs. Anything more than two tables will never be fully optimized, while multiple joins *may* be. There is more information in the Rushmore KB article on my web site.
I guess im going to have to do it that way. I had started it all in SQL server and only came across this when I was bringing back to vfp and was hoping for a quick way around it.
Thanks.
Michael Henstock
AWS
A fish this fine deserves to be a fish nugget styled chunklet.
- Fry