OpenQuery SQL returns different results
<p>I have setup a view in an Oracle database that runs the code:</p>

<pre><code>select *
from Availabilities
</code></pre>

<p>This returns the results</p>

<pre><code>Roster | StartDate | EndDate
Avail  | 18/5/16   | 18/5/16
Train  | 19/5/16   | 19/5/16
Avail  | 20/5/16   | 30/5/16
</code></pre>

<p>these results are correct and are as expected, however...   </p>

<p>I have linked the server that this view is on to an SQL server. From there I run an OpenQuery directly to the view that produced that results set on the linked server through the code:</p>

<pre><code>select *
from OpenQuery(LinkedServer,'SELECT *
FROM REPORT_USR.AvailabilitiesView')
</code></pre>

<p>The results it returns have combined the first and the third results:</p>

<pre><code>Roster | StartDate | EndDate
Train  | 18/5/16   | 30/5/16
Avail  | 19/5/16   | 19/5/16
</code></pre>

<p>Why would it do this?  Is there a way to stop it doing this?</p>

<p>Thanks</p>