Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

inner join... no data

hemant_kFeb 8 2024

hi

create tabl a ( id number)

insert into a values(100);

insert into a values(200)
--
create table b (id number)
 insert into b values (300);
 insert into b values (400)
 
 select nvl(x.id,0) from a x inner join b y on x.id=y.id
 result..
 no data found
 how can I display 0 here ?

please help

Comments
Post Details
Added on Feb 8 2024
36 comments
278 views