You can use the ALL keyword in the UNION statement to get all the records. Read the Help on "Select - SQL" carefully.
Bill
>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
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.