Select top 10 * from OPENDATASOURCE('SQLOLEDB','Data Source=192.168.0.16 User ID=wer;Password=wer').awstats.dbo.awstats inner join tab_order on awstats.siteid = tab_order.order_id where awstats.prod_date<getdate() order by awstats.prod_date desc
本机上的SQL和局域网内的另一台机器上的可以这样join吗？不行的话应该怎么样?我这样写，是每成功!
sql不支持4个字段
改一下把远程表用一个别名a就行了：
Select top 10 * from OPENDATASOURCE('SQLOLEDB','Data Source=192.168.0.16 User ID=wer;Password=wer').awstats.dbo.awstats as a
inner join tab_order on a.siteid = tab_order.order_id where a.prod_date<getdate() order by a.prod_date desc
楼主192.168.0.16 后面少了分号
Select top 10 * from OPENDATASOURCE('SQLOLEDB','Data Source=192.168.0.16;User ID=wer;Password=wer').awstats.dbo.awstats inner join tab_order on awstats.siteid = tab_order.order_id where awstats.prod_date<getdate() order by awstats.prod_date desc
