Copy the select statement into the command window and try to run with one join condition at time.
>When I choose "suspend" the debugger breaks at the first line of the select statement.
>
>>Which command gives you this error?
>
>>Hi Sergey,
>>I am now getting an "Operator/Operand type mismatch" How do I determine which fields are causing this error? The fields are of the same name, type and width so could it be something else?
>>
>>>>Here's corrected code
>>
>>>>Select tableA.field5 as fieldtotal ;
>> FROM tableA ;
>> INNER JOIN tableB ON tableA.namefield = tableB.namefield ;
>> AND tableA.datefield = tableB.datefield
>> INTO cursor crsTemp
>>
>> SELECT mytable
>> append from ( dbf('crsTemp') )
--sb--