Oracle - Combine Two Separate Tables

GeekInterview.com > Tech FAQs > Oracle

Go To First | Previous Question | Next Question

Oracle | Question 228 of 244

Combine Two Separate Tables

How to combine two separate table into one?

Total Answers and Comments: 3

Last Update: July 23, 2009 Asked by: micky_121

Sponsored Links

Best Rated Answer

—

Submitted by: malli434

By using join concepts we can combine more than one table.. Can you try with any one of the join concept. you will get the output.

Ex.
Table 1( Emp)Â Â Â Â Â Â Â Â Â
Columns: Empno,ename,job,sal,comm,deptno

Table 2(Dept)
Columns :deptno,dname,loc

Query : select empno,ename,job,sal,comm,e.deptno dno,dname,loc from emp e,dept d
where e.deptno=d.deptno;

Above answer was rated as good by the following members:
mittu.jangid

January 02, 2009 22:51:08

malli434

Member Since: September 2008 Contribution: 1

RE: Combine Two Separate Tables

By using join concepts we can combine more than one table.. Can you try with any one of the join concept. you will get the output.

Ex.
Table 1( Emp)
Columns: Empno ename job sal comm deptno

Table 2(Dept)
Columns :deptno dname loc

Query : select empno ename job sal comm e.deptno dno dname loc from emp e dept d
where e.deptno d.deptno;

Is this answer useful? Yes | No

1 0