This discussion is archived
4 Replies Latest reply: Nov 19, 2012 12:31 AM by Manik RSS

how to rewrite this sql

969801 Newbie
Currently Being Moderated
<div class="jive-quote">
create table e(id number,name1 varchar2(20),name2 varchar2(20));

insert into e values(1,'a','b');
insert into e values(2,'c','d');
insert into e values(3,'e','f');

select * from b

drop table e;
create table b(sid number,rid number);

insert into b values (1,2);


select sid , e.name1,rid ,f.name2
from e,b,e f
where e.id=b.sid and b.rid=f.id;
</div>



is there any way to rewrite this sql? just a join b ..

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points