The problem is that you are doing a left outer join to REQUEST_TEXT.

If you do an inner join, the condition (WHERE TEXT_LINE_CODE <> 'RAQA') will result in these lines being...

If you drop the 'AND d.y=c.y' condition from the last join, the results from the two queries are identical (as you would expect).

Including it gives you different subsets of the...