4 Replies Latest reply: Nov 19, 2012 2:39 AM by 969801 RSS

    how to rewrite this sql

    969801
      <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 ..