Hello.
I wonder if anybody has an explanation for this:
I have a MSSQL server, a database in it, and some tables. I made a openquery to get data from a remote Oracle database that I am trying to combine with some data on this server. Everything works fine, my question is about behavior. If my openquery has more than 3 WHERE clauses, it returns only one record.
Like in WHERE field1='A' AND Filed2='B' AND filed3='C' is ok and
WHERE field1='A' AND Filed2='B' AND filed3='C' AND 1=1 returns only one record.
Thank you