Sorry
I had missed the outer join in my second query
it is
[CODE=oracle]select a2 from table_a,table_b where table_a.a1=tabl e_b.b1 (+) and table_b.b1=9999 99[/CODE]
and the result set of this is different from
[CODE=oracle]select a2 from table_a left outer join table_b on table_a.a1=Tabl e_b.b2 and table_b.b1=9999 99[/CODE]...
rneel
Last Activity: Jul 2 '07, 07:52 AM
Joined: Apr 12 '07
Location:
-
results of left outer join and =(+) in oracle are different
I have a query which performs the following
[CODE=oracle]
Select a2 from table_a left outer join table_b on table_a.a1=tabl e_b.b1 and table_b.b1=9999 99[/CODE]
The result of set of this is different from
[CODE=oracle]
select a2 from table_a,table_b where table_a.a1=tabl e_b.b1 and table_b.b1=9999 99
[/CODE]
I am using oracle 9i... Why is it different...
Not too... -
null value in joins
i have two tables a1 and b1. they have a common column which is not having any constraints... they have null values... when i use a join between the two columns the null values are neglected... how do i include the null values in the joins...
need help
r -neel -
need help in update statement
i have the following structure table a1
NO DEPT
--------- ----------
1 2
1 3
1 4
1
table a2 has the following structure
NO DEPT
--------- ----------
1
I need to update a2 so the at the end a2 has the same set or rows as a1... i get an error -- single subquery...
No activity results to display
Leave a comment: