Does anyone know how to join a table on itself in progress? For example, in SQL you would just put select * from table1 t1 inner join table1 t2 on t1.name = t2.name.
Ryan
Are you doing this in SQL or in ABL?
If ABL, is it a query, for each, repeat, or what.
define buffer table-name-2 for table-name.
for each table-name no-lock,
each table-name-2 where table-name-2.field-name = table-name.field-name
etc.
Thanks. The buffer table worked.