Thanks but if i do this, it only gives me identical records, it seems to eliminate duplicates. , my result table should contain 670 records but it only contains 91.

Tanks


>Stephane,
>
>You should use this:
>
>SELECT [fieldlist] FROM TABLE A ;
>UNION ;
>SELECT [fieldlist] FROM TABLE B
>
>Make sure both fieldlists are compatible, because the union clause can only be used this way. Look in the VFP Help for more info about the UNION clause in a SQL - Select.
>
>Regards,
>Frank Camp