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

SELECT * FROM OrdLines ;
 UNION ALL ;
  SELECT * FROM Ordlines_history ;
 INTO CURSOR OrdLines_total