I'm having a problem with the results of a stored procedure using a table from a linked server (Oracle).
It seems not all of the data is returned from the field in the Oracle table, yet I know that the field in question is populated.
I've tried altering the joins, changing the linked fields, swapping the order of the joins, but it still only returns some and not all of the data.
This is the query from the procedure:
SELECT DISTINCT ld.Object_id, ld.Academic_year, ld.Course_Title, qc.COURSE_LEVEL
FROM QUERCUS..QUERCUS.COURSE AS qc RIGHT OUTER JOIN
dbo.Learner_Destination AS ld ON qc.DESCRIPTION = ld.Course_Title
GROUP BY ld.Object_id, ld.Academic_year, ld.Course_Title, qc.COURSE_LEVEL
ORDER BY ld.Course_Title
At first I thought the values in the qc.Description field and ld.Course_Title field were different, but they are both the same.
But still I can't get all the data from the qc.COURSE_LEVEL field.
Has anyone encountered a similar problem with linked servers?