Link Tables

Hi,
Still i m not getting the result. My question is can link the table in SQL like MSAccess has.(from other database we can use the table). Bcz i want a data from other database table and use the table data for other database.

Thanks
imtdid u mean to join the table or database....

Quote:

Originally Posted by imtmub

Hi,
Still i m not getting the result. My question is can link the table in SQL like MSAccess has.(from other database we can use the table). Bcz i want a data from other database table and use the table data for other database.

Thanks
imt

|||

Quote:

Originally Posted by reon

did u mean to join the table or database....

I want if the data change one table it need to sutomatically update second table. The both table are not in one database. They are diffrent database in sql server. In Access i can use link table to get data from another database table. In sql i don;t know how to use. If anybody knows how to do this option it will very helpfull.

Thanks