SQL Language (MOSC)

MOSC Banner

11g : similar queries but different results !

edited May 5, 2013 10:04PM in SQL Language (MOSC) 2 commentsAnswered ✓
Hi ,

I have two "similar" queries :


QUERY 1 : No rows returned

Select F1.ID_FACT
From FACTORIES F1
LEFT JOIN FACTORIES F2
ON F1.ID_FACT = F2.ID_FACT
Where F1.NO_REF = 62
and F2.NO_REF = 61
and F2.ID_FACT is null;
---------------------------

QUERY 2 : 1050 rows returned

Select F1.ID_FACT
From FACTORIES F1 , FACTORIES F2
Where F1.ID_FACT = F2.ID_FACT(+)
and F1.NO_REF = 62
and F2.NO_REF(+)= 61
and F2.ID_FACT is null;


Why QUERY 1 result is diffrent to QUERY 2 result !

Best regards.
GD.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center