What is relation between yourtable and histable?

SELECT * FROM yourtable,  histable ;
  INTO CURSOR crsTemp
SELECT mytable
APPEND FROM ( DBF("crsTemp"))

will add all posible combinations from yourtable and histable.


>Hi all,
>
>How to get a filename while appending the records from mytable.dbf ?
>
>select mytable with two fields
>dbftype empno#
>
>append from yourtable && contains only empno# field
>append form histable && contains only empno# field
>
>in order to have at the end in mytable two fields :
>
>dbftype empno#
>yourtable 10000
>histable 20000
>
>Please help in coding.
>TIA
>Paul