查看: 1317|回复: 4
|
请问要如何 merge 两个 database
[复制链接]
|
|
如果有 db1 里面有 3 个 table,
db2 里面有 2 个 table,
要如何把两个 db merge 起来,变成
db1 里面有 5 个 table ? |
|
|
|
|
|
|
|
发表于 20-12-2007 07:00 PM
|
显示全部楼层
版主表block我哦。我用英文比较容易解释。
ok, u go to "TOOLS" on up there....
den,,,choose "relationships"
den, u'll be able to choose those tables u wan to link together.
if u wan to link "date" to "payment"
just click+hold ur mouse on "date",,,, den DRAG ur mouse to "payment"
den this 2 data will be linked.
(there will b 3 small boxes, jz click both 3 of the small boxes den press "create" den can liao)
well, now
ok, u go "Query" it is just 1 section down of "table"
den, choose "create query in Design View"
den, u choose those tables u want. and click "Add"
den it will show in the screen there.(u'll see)
den, u'll see that those data u linked in "relationships" jz now has a line there(there has been linked).
den, down there got several columns.
u jz key-in those data u needed for.
thats it=) |
|
|
|
|
|
|
|
![](static/image/common/ico_lz.png)
楼主 |
发表于 20-12-2007 08:35 PM
|
显示全部楼层
原帖由 sokaigy 于 20-12-2007 07:00 PM 发表 ![](http://chinese.cari.com.my/myforum/images/common/back.gif)
版主表block我哦。我用英文比较容易解释。
ok, u go to "TOOLS" on up there....
den,,,choose "relationships"
den, u'll be able to choose those tables u wan to link together.
if u wan to link " ...
用什么tools ? |
|
|
|
|
|
|
|
发表于 21-12-2007 08:19 PM
|
显示全部楼层
|
|
|
|
|
|
|
发表于 10-1-2008 02:07 AM
|
显示全部楼层
|
|
|
|
|
|
| |
本周最热论坛帖子
|