I hope this time I udarstand you correctly.

SELECT PADR("yourtable",8) AS dbftype, empno ;
  FROM  yourtable ;
UNION ;   
SELECT PADR("histable",8) AS dbftype, empno ;
  FROM  histable ;
  INTO CURSOR crsTemp
SELECT mytable
APPEND FROM ( DBF("crsTemp"))

>Sergey,
>
>I would like to have a table name yourtable and histable attached or added as a new field in mytable at the end.
>
>yourtable.dbf and histable.dbf have only 1 field and both have same structure
>empno#
>10000 yourtable
>20000 histable
>
>mytable.dbf when append from yourtable and histable should have 2 fields
>
>dbftype empno#
>yourtable 10000
>histable 20000
>
>dbftype have 8 characters like DOS filename, the fact behind this is to get
>the filename added to mytable. dbftype C(8), empno C(5)
>
>TIA
>Paul