4 Replies Latest reply on Nov 19, 2012 8:39 AM by 969801

    how to rewrite this sql

      <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;

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