>>>Hi all,
>>>Is there any quick way to merge 2 table into 1?
>>>Thanks,
>>>Tamas
>>
>>Depending on what do you mean by that - vertical or horisontal merge?
>>
>>If both tables have the same structure and you want to append records from one to another, then look into INSERT SQL or APPEND FROM commands.
>>
>>If you want to add extra fields, when how do you want to combine records - based on some key field?
>
>I'd like to merge them vertically.
>for example:
>

>*********
>table1
>
>field1  | field2
>a1	| b1
>a2	| b2
>
>*********
>table2
>
>field3  | field4
>c1	| d1
>c2	| d2
>
>*********
>mergedtable
>
>field1  | field2 | field3 | field4
>a1	| b1	 | c1	  | d1
>a2	| b2	 | c2	  | d2
>

Assuming that reccount() is the same in both tables.

Select recno() as recnum,field1,field2 from table1 into cursot tmp1 nofilter
Select recno() as recnum,field3,field4 from table2 into cursot tmp2 nofilter
Select field1,field2,field3,field4 from tmp1 inner join tmp2 on tmp1.recnum=tmp2.recnum

Use Outer Join in case of different record counts.