How to combined table 2 value in table 1 whare id field is same?
Oh foxpro  my first programing language   

Visual Foxpro 5+ can run most of the SQL92 commands with modifications to its syntax

standard sql commands will work for a join

Select * from table1 left join table2 on table2.id = table1.id 
into cursor my_joined_tabled


this will create a read only cursor  aka in memory only table.  Cursor in foxpro are in memory tables  

for a union 

select cast(columns to same data type), and number of columns from table1
union 
select cast(columns to same data type), and number of columns from table2
into cursor my_unioned_table


if you want to use Xbase commands  that's allot more code and those brains cells fell dormant 10 years ago