2.1w+
社区成员
如何取两个数据库中的某几个表做视图?(在线疯等)
例如:
A数据库中有个AA表
AA表结构为 AA1 AA2 AA3
B数据库中有个BB表
BB表结构为 BB1 BB2 BB3
如何在B数据库建AA表.AA1=BB表.BB1 的视图
A数据库中有个AA表
AA表结构为 AA1 AA2 AA3
B数据库中有个BB表
BB表结构为 BB1 BB2 BB3
如何在B数据库建AA表.AA1=BB表.BB1 的视图
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
wgsasd311 2006-03-13
create view V_AB
as
select A.*,B.bb2,bb3
from BB B
inner join A.dbo.AA A on A.AA1=B.BB1
as
select A.*,B.bb2,bb3
from BB B
inner join A.dbo.AA A on A.AA1=B.BB1
lsqkeke 2006-03-13
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
go
create view V_A_B
as
select A.*,B.*
from BB B
inner join A.dbo.AA A on A.AA1=B.BB1
xueguang 2006-03-12
create view v1 as select B.* from A..AA A,BB B where A.AA1=B.BB1
OracleRoob 2006-03-12
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
as
select A.*,B.*
from A.dbo.AA A
inner join B.dbo.BB B on A.AA1=B.BB1
「风险评估」支持国产密码算法的OpenSSL设计实现及应用 - 金融安全.zip 「风险评估」支持国产密码算法的OpenSSL设计实现及应用 - 金融安全
WAF
基础架构安全
WAF
网络安全
APT
kernel-plus-headers-3.10.0-1160.6.1.el7.centos.plus.x86_64.rpm kernel-plus-headers-3.10.0-1160.6.1.el7.centos.plus.x86_64.rpm
