OraFAQ Forum: SQL & PL/SQL » how to add to the right side of my table, the colums and data of 2 other tables .

Home » SQL & PL/SQL » SQL & PL/SQL » how to add to the right side of my table, the colums and data of 2 other tables . (Oracle 12c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to add to the right side of my table, the colums and data of 2 other tables . [message #662636]

Mon, 08 May 2017 09:07

mpniel
Messages: 4
Registered: February 2007

Junior Member

Is it possible with a select statement, to add to the right side of table A , the colums and data of 2 other tables B and C .
Example:
table A: col1 (pk) , col2 -- 10 rows
table B: col3 (pk) , col4 -- 10 rows
table C: col5 (pk) , col6 -- 10 rows

Each table have all pk values that exist on the other 2 tables.

the result should be as follows:
table A: col1 (pk) , col 2 , col4, col6

Report message to a moderator

Re: how to add to the right side of my table, the colums and data of 2 other tables . [message #662637 is a reply to message #662636]

Mon, 08 May 2017 09:10

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

Sounds like a simple join, for example,

orclz>
orclz> select emp.ename,dept.dname from emp join dept on(emp.deptno=dept.deptno);

ENAME      DNAME
---------- --------------
CLARK      ACCOUNTING
KING       ACCOUNTING
MILLER     ACCOUNTING
JONES      RESEARCH
FORD       RESEARCH
ADAMS      RESEARCH

Report message to a moderator