Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> RE: Joining two tables without primary keys
Hi Rajesh,
you can use the following select statement:
select t1.r1, t1.r2,
(select distinct r3 from tab2 where t1.r1=r1 and t1.r2=r2) r3 from tab1 t1
Best regards,
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com
Received on Thu Jul 05 2001 - 22:25:49 CDT