如何將兩個表combine 埋一齊？（要用SQL）

FoxPro? 用 FoxPro command 好嗎?

let tableA & tableB store in c:\temp

CLOSE ALL
CLEAR ALL
CLEAR

CD C:\temp

USE tableA IN 0
USE tableB IN 0

SELECT tableA

APPEND FROM tableB

就算用 SQL, 你也要用
USE tableA IN 0
USE tableB IN 0
才能用 insert statement

ok?

insert into TableA select * from TableB
or
insert into TableA (column1, column2,...) select column1, column2,... from TableB