hi,
I wanted 2 do some thing like this..
Select A.C1, A.C2
From A
LEFT JOIN B
ON A.C1 = B.C1 AND B.C2 = (SELECT T.C1 FROM T WHERE B.C2 = T.C1);
How can i do dis?
It is giving me exception :: ORA-01799: a column may not be outer-joined to a subquery
but
Select A.C1, A.C2
From A
LEFT JOIN B
ON A.C1 = B.C1 AND B.C2 = 5;
is working fine