> My deleted() setting is off as well as i am not using deleted() option in query
As GB has been trying to tell you, you can't use the DELETED() function in a query that has more than one table in the FROM clause. The problem is that VFP doesn't know which table you're referring to and you'll get different results at different times.
In general, when a query involves more than one table, never use any function that accepts an alias as one of its parameters.
Tamar