Same query but returned different records
I ran the following query through sqplus and got 109 records returned, I login to another session and ran the same query but got 47 records returned. If I used the distinct for the select clause, I will get 47 records for both sessions. I like to know what causing the inconsistent reponse from the same query.
SELECT /*+ RULE */
old_tl.document_id,
old_e.top_level_element_id,
old_e.element_state_id,
old_e.element_id AS source_element_id
FROM
element old_e, top_level_element old_tl
WHERE
old_tl.document_id=6488 and
old_tl.responder_document_id = 42896 AND
old_e.top_level_element_id = old_tl.element_id AND
old_e.element_state_id IN (6, 7)
ORDER BY old_e.source_element_id;