Hi All,
I have two queries and there is a count mismatch in both queries. I couldn't understand why it is different because to me both of these look similar. Please help me with understanding.
Query 1 -
SELECT COUNT (*)
FROM (
SELECT t1.c3
, t2.c3
FROM t1 t1
, t2 t2
WHERE 1 = 1
AND t1.c1 = 'A'
AND t1.c2 = t2.c2 (+))
Query 2 -
SELECT COUNT (*)
FROM (
SELECT t1.c3
, ( SELECT t2.c3
FROM t2 t2
WHERE t1.c2 = t2.c2 (+))
FROM t1 t1
WHERE t1.c1 = 'A')