compare two columns (oracle 9i)

Gurus,

I would like to compare two columns from two different tables without
creating cursor. Is it possible?

create table r1 (col1 varchar2(10));
create table r2 (col2 varchar2(15));
insert into r1 values ('TEVE');
insert into r2 values ('STEVE');
insert into r1 values ('OM');
insert into r2 values ('TOM');
insert into r1 values ('JIM');
insert into r2 values ('BUSH');

SQL> select col1 from r1;

COL1
----------
TEVE
OM
JIM

SQL> select col2 from r2;

COL2
---------------
STEVE
TOM
BUSH

SQL> select col2 from r1,r2 where col2 like '%col1%';

no rows selected

Above Query doesn't return any rows?

Thanks
Bob


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
--
http://www.freelists.org/webpage/oracle-l

Other related posts: