>>I'm getting the error "too many subqueries", but I don't have any subqueries. I thought maybe it meant too many joins since I have 10, but I'm sure I've had that many before.
>>
>>Any ideas?
>>
>>Thanks,
>>
>>Michelle
>
>

---

Unfortunately that's the case and AFAIK limited to 10. When hit me I divided the SQL into 2-3. If you have a better solution lemme know too.
>Cetin

Seems to be limited to 9. It fixed it when I chopped one off. I'll see if I can restructure it.

Thanks,

Michelle