>
>It doesn't have anything to do with DBC. VFP9 detects more memo field corruptions. You don't get error with USE because it doesn't access record(s) with corrupted memo. You could try to pack the table in previous version of VFP.
You are right. I just ran the inner joint in VFP 6 and it gives good results. So I am sure once I get the table "cleaned", the entire SQL Select will work. Again, thank you very much. Every time I am talking to you I learn so much, I appreciate it very much!
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham