Raul wrote:

On 3/24/2015 11:25 AM, Boss wrote:
> I tried your suggestion I got the following error DBISAM Engine Error # 11949 SQL parsing error - Expected column name but instead found i1.loan_id in SELECT SQL

This error just indicates that column name could not be matched - it's
simply a name parsing issue and not a SQL error per-se.

Double-check that your table name and alias name (i1 and i2) are ok in
the SQL.

Does it work when you run it in in DBSYS ?

What version of dbisam are you using (or odbs driver in your case
possibly i guess if you're on VS)?

Raul


Thank RAUL! it worked.