>>Thanks Borislav. There must be something more cause I'm not getting a result cursor. Here is my code.
>>

>>text TO this.oCa.SelectCmd PRETEXT 15 NOSHOW
>>     SELECT test_financing.keyID, Test_financing.tip_id, Test_financing.amount,
>>            Test_financing.source, Test_financing._year, test_phases.phase
>>            FROM \\tpdfiles\data\dfreeman\tip\data\TEST_FINANCING.DBF
>>            left join test_phases on test_financing.tip_id = test_phases.tip_id
>>            WHERE  Test_financing._year = ( ?m.lnYear )
>>    ORDER BY Test_financing.tip_id
>>endtext
>>

>
>Did you test your query separately first? Does it return the data?


DUH!! Let me work on this some more. Thanks