You need to check out OPENROWSET and OPENQUERY in Books Online. These allow distributed queries.


>Thanks for your reply, after the new link created it's working now, but how to create inner join between them?, I try to use the below statement for joinning tables in 2 links:
>
>Select Sales.*, MyLink.DBStock.dbo.Stock.StockName from Sales Inner Join MyLink.DBStock.dbo.Stock On Sales.StockCode = MyLink.DBStock.dbo.Stock.StockCode Order by Sales.SalesDate
>
>The errors will occurs .. can you help? .. thanks a lot before
>
>Best Regards
>Wina