Hellow:

I need to join two files which are hold on table , but always show this error message
(FOC1070) VALUE FOR JOIN 'FROM' FIELD OUT OF SEQUENCE. RETRIEVAL ENDED
, i don't know what's the problem

Has any body come across this problem?
Thanks in Advance!

The simplest thing to correct this is to ensure that both hold files you have created are sorted in the same order (same BY fields).

Thank you ,Piipster
but I am sure that two files has the same BY fields..

this error message happens when, just as piipster says, the join fields are out of sequence. And its always a user error..even tho we are sure it isn't..and we've all done it.
make sure your join field is the first BY field in each file.

One additional thing you might try is stating hour hold statement:

ON TABLE HOLD AS HOLD1 FORMAT FOCUS INDEX FIELD1

Where FIELD1 is the field you are joining on. If you will do this on the guest of the join statement you may find the program will get past the join a little better...but ultimately, it is as Suzannah said...we've all done it and swear it is done right for about 8 hours until it hits us in the face what we've done! <smile>

I have tried Stan's suggestion, and then it works.
Thanks to everybody for the answers