Very Computer

Hi,
 Is it possible to create a view from tables in the different database using
T-SQL?if possible,
pls send the T-SQL statement.

Thanks in advance,
Venkat

sure...

create view venkat
as
select royalty
from pubs..titles
union all
select orderid
from northwind..orders
go

select * from venkat
go
drop view venkat
go

-oj

Quote:> Hi,
>  Is it possible to create a view from tables in the different database
using
> T-SQL?if possible,
> pls send the T-SQL statement.

> Thanks in advance,
> Venkat

Thanks OJ

Hi experts,
   I have to create a view from tables in different databases.
say,
     Databases :    DB1  DB2  DB3
     Tables    :    T1  T2  T3
     Rows      :    index1      index2          index3
    ID  ID
    Name  Name

Here i want to check whether index1 is equal to index2.Suppose if it is
equal,then i have to
retrieve the ID and Name to show in the view.This i have done using this
T-SQL
 use DB1
 if exists(select ID,Name from T1,DB2..T2 where T1.index1 = DB2..T2.index2)
 DROP VIEW view7
 GO
 create view view7 as select ID,Name from T1,DB2..T2 where T1.index1 =
DB2..T2.index2
 GO
But here i also have to check whether index1 is equal to index3,if it equals
then i have to update
in the view7 in the same ID and Name fields.I have tried using Many T-SQL
statements,but i can't
find the solution.

Thanks in advance,
venkat