>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