Re: SQL question

Try this
SQL> select * from test1;

        ID

         1
         2
         3

SQL> select * from test2;

        ID

         2
         3
         4

SQL> select A.ID OLDID , b.id NEWID
  2 from test1 a,
  3 TEST2 B
  4 where a.id = B.id (+)
  5 UNION
  6 select C.ID OLDID , D.id NEWID
  7 from test1 C,
  8 TEST2 D
  9 where C.id (+) = D.id;

     OLDID NEWID
__________ __________

         1
         2          2
         3          3
                     4

SQL> HTH Conan Received on Wed Aug 09 2000 - 00:00:00 CDT