>********* >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.recnumUse Outer Join in case of different record counts.