>>>>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
>
>

---

Ohh maybe by chance it's length of command line. I had failed on 11th, 10 worked.
>Cetin

Maybe it's number of tables. I have 10 tables, 9 joins.

Thanks,

Michelle