I have a problem with join on a linked server.
with this query the result is correct:
select top 10 A.* from [business].[metcube].[dbo].[movmag] A left join [business].[metcube].[dbo].[artico] B on A.mm_codart= B.ar_codart
with this query i obtain non correct results:
select top 10 A.mm_codart from [business].[metcube].[dbo].[movmag] A left join [business].[metcube].[dbo].[artico] B on A.mm_codart= B.ar_codart
The linked server, name business, is a Microsoft Sql Server.
If i import the tables movmag and artico and execute queries on the primary server the results is correct in both cases.
Thanks