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
Winan