>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