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