join 2 tables [message #10373] |
Mon, 19 January 2004 00:28 |
ubaid
Messages: 2 Registered: December 2003
|
Junior Member |
|
|
hi all,
how to join 2 different tables( when there is no common column between them) like join table˙AA =>˙columns srno(number),sal(number) with table BB˙ => columns stock(number).
thanx in advance.
˙
|
|
|
|
|
|
Re: join 2 tables [message #10398 is a reply to message #10376] |
Tue, 20 January 2004 23:12 |
obed khan
Messages: 2 Registered: December 2003
|
Junior Member |
|
|
join using emp and dept tables with different columns
the query is
select ename,dname from emp,(select empno,dname from
(select rr,empno,dname,r from(select rownum rr,empno
from emp),(select rownum r,dname from dept))
where r=rr) v
where emp.empno=v.empno(+)
|
|
|