Answer Detail: RE: Combine Two Separate Tables

GeekInterview.com > Tech FAQs > Oracle

Print |

Question: Combine Two Separate Tables

Answer: How to combine two separate table into one?

January 01, 2009 22:51:08	#1
malli434	Member Since: September 2008 Total Comments: 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;