我有兩個表，A同埋B
入面oD variable 係一毛一樣，我點樣可以將B入面oD資料，抄去Ao個度？（需要用SQL寫）
個SQL係o係Foxpro度寫
如何將兩個表combine 埋一齊？（要用SQL）
2007-10-11 6:10 am
回答 (2)
2007-10-11 6:25 pm
✔ 最佳答案
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?
2007-10-11 7:27 am
insert into TableA select * from TableB
or
insert into TableA (column1, column2,...) select column1, column2,... from TableB
or
insert into TableA (column1, column2,...) select column1, column2,... from TableB
收錄日期: 2021-04-25 20:34:28
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20071010000051KK04202