Subject | Connect 2 databases |
---|---|
Author | Tiago PerSan |
Post date | 2004-01-21T20:39:08Z |
Hello all,
Is possible to use tables of diferents databases in one view.
for example in MSSQL I use :
Create view a_plus_b as
(
select a.user_name, a.cd_user,
b.adress, b.number
from test.dbo.a, test2.dbo.b
where a.cd_user = b.cd_user
)
Someone can help me ???
Thanks...
[Non-text portions of this message have been removed]
Is possible to use tables of diferents databases in one view.
for example in MSSQL I use :
Create view a_plus_b as
(
select a.user_name, a.cd_user,
b.adress, b.number
from test.dbo.a, test2.dbo.b
where a.cd_user = b.cd_user
)
Someone can help me ???
Thanks...
[Non-text portions of this message have been removed]