>Hello,
>
>I have the following question:
>
>Is it possible to link 2 or more free tables with Sql-select ?
>
>The tables i use are ordlines.dbf and ordlines_history.dbf the fieldnames are identical and the records are all unique. I want to have them into 1 new cursor called ordlines_total.
>
>Can this be done without using a r/w cursor with append from ....
>
>Thanks in advance

You could look into the UNION clause of SELECT - SQL. However, Unions tend to be amongst the slowest SELECT - SQL operations, especially with large tables.

If you're looking to do computations on columns you could do also look into the SUM() and COUNT() operators for SELECT - SQL.

Or, it may be simpler and run faster to use CALCULATE SUM ... etc. on the tables separately, then add up the values afterwards.