>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