>I have a table called subject with three fields of the same datatype.
>how I can append all these records from the table subject to another new table in one field only.
>
>any help
>thank you
select field1 as NewField from myTable ;
union all ;
select field2 as NewField from myTable ;
union all ;
select field3 as NewField from myTable ;
into cursor crsTrans nofilter
select TableB
append from dbf('crsTrans')
Cetin