如何取两个数据库中的某几个表做视图?(在线疯等)

[lovecssxml]

例如:

A数据库中有个AA表
AA表结构为 AA1 AA2 AA3
B数据库中有个BB表
BB表结构为 BB1 BB2 BB3
如何在B数据库建AA表.AA1=BB表.BB1 的视图

[OracleRoob]

create view V_A_B
as
select A.*,B.*
from A.dbo.AA A
inner join B.dbo.BB B on A.AA1=B.BB1

[ddxxx112]

create view v1 as select B.* from A..AA A,BB B where A.AA1=B.BB1

[lsqkeke]

use B
go
create view V_A_B
as
select A.*,B.*
from BB B
inner join A.dbo.AA A on A.AA1=B.BB1

[wgsasd311]

create view V_AB
as
select A.*,B.bb2,bb3
from BB B
inner join A.dbo.AA A on A.AA1=B.BB1