outer join problem [message #327915] |
Wed, 18 June 2008 06:32  |
rzkhan
Messages: 370 Registered: March 2005
|
Senior Member |
|
|
I get the same no of rows even after outer join.
Can any guy help me ?
Thanks
SQL> ed
Wrote file afiedt.buf
1 select count(*)
2 from
3 (
4 select cardno,testcentre
5 from bsd
6 order by 2 desc
7* )
8 /
COUNT(*)
----------
4612
SQL> ed
Wrote file afiedt.buf
1 select count(*)
2 from
3 (
4 select cardno,centre
5 from bsd,centres
6 where bsd.testcentre=centres.centre_id
7 order by 2 desc
8* )
SQL> /
COUNT(*)
----------
4554
SQL> ed
Wrote file afiedt.buf
1 select count(*)
2 from
3 (
4 select cardno,centre
5 from bsd,centres
6 where bsd.testcentre(+)=centres.centre_id
7 order by 2 desc
8* )
SQL> /
COUNT(*)
----------
4554
SQL>
|
|
|
|
|
|