Hi again,

After reviewing the WHERE section of my SELECT clause I realized that there was a condition missing there in order to make the tables combination unique. Without this condition the result set was kind of ambiguous so I think the MAX was returning unexpected results.
I have tested it over four or five separate scenarios and now it seems to be working OK.

Thanks for helping,

>Hi,
>
>I have an application (EXE file) written in VFP which is supposed to extract data from our database (using SQL-SELECT clauses) and put it in a set of DBFs (which are re-created by the app each and every time it runs). The fact is that when I run it over a local database in stand-alone mode it gets the expected results, but when I run it against the production database the app produces a different result.
>Has anyone had the same problem? I do not understand why is this happening, maybe I need to open the database in exclusive mode?
>
>TIA,