由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - sql server里怎么create 跨database的 view
相关主题
Can I create thousands table in one...How to create a new database under SQL 7.0 from remote host?
more q: how to make database size smallerRe: How to create a new database under SQL 7.0 from remote host?
Access database 求助create database 在oracle中有什么用处?
请教一个sql的问题database design issue
请教一个sqlplus的问题mysql maximum columns <=1000?
请教个数据管理的问题Question on create a database in DB2
Asking help for Access!:(Any SSIS high hand here?
请教一个问题Oracle table 备份问题
相关话题的讨论汇总
话题: view话题: create话题: databases
进入Database版参与讨论
1 (共1页)
l********u
发帖数: 195
1
需要同时view data from tables from different databases. how can I create a
view that across different databases?
Thanks
B*****g
发帖数: 34098
2
create view a_view
as
select a.*, b.*
from db1.schema1.tab1 a, db2.schema2.tab2 b
where ....



【在 l********u 的大作中提到】
: 需要同时view data from tables from different databases. how can I create a
: view that across different databases?
: Thanks

1 (共1页)
进入Database版参与讨论
相关主题
Oracle table 备份问题请教一个sqlplus的问题
a question on database design请教个数据管理的问题
In toad, Asking help for Access!:(
请帮我看看,什么地方错了?请教一个问题
Can I create thousands table in one...How to create a new database under SQL 7.0 from remote host?
more q: how to make database size smallerRe: How to create a new database under SQL 7.0 from remote host?
Access database 求助create database 在oracle中有什么用处?
请教一个sql的问题database design issue
相关话题的讨论汇总
话题: view话题: create话题: databases