>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?