>Hi Naomi,
>Thank you for your suggestions, but I already did a delete tag all and deleted the indexes and recreated all of them for all the tables. It didn't help.
>The qlp-all table has 23 fields, about 468,000. Would 23 fields cause this? I can always test with a few fields from qlp-all.
>I appreciate the suggestions. I hope to have this figured out.
1. Using Cetin's suggestion try to rename qlp-all to qlp_all
2. Try to make your SQL to be ANSI compatible
3. Try with only few fields from q table.
If it's not broken, fix it until it is.
My Blog