如何查找sql2000两个库的信息。(100)

Z

zkktom

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-03-17

• #1

一个库里存了员工信息一个库里也村了员工信息。我向用一句sql得到所有员工信息，该如何出来！select * from yg1 ygxx1库 select * from yg1 ygxx2库

 

D

de410

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-03-17

• #2

select * from ygxx1库.dbo.yg1,ygxx2库.dbo.yg1

 

Z

znxia

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-03-17

• #3

select * from 库1.dbo.departUNION ALLselect * from 库2.dbo.depart

 

Z

zkktom

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-03-18

• #4

多人接受答案了。