Hi All,
I am trying to do a inner join on a table which resides both in attunity(200 rows) and in sql server(1 million rows). i have created a linked server to attunity from sql server.I use the following syntax to do a inner join on these tables and get the results from Attunity.But the query is behaving oddly i.e. it is returning more rows than that are present in attunity.
I don not understand why it is happening???Is it because of some null values in the some of the columns???Please give me your advice....
Thanks...