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