Combine Two Separate Tables

How to combine two separate table into one?

Questions by micky_121

Showing Answers 1 - 9 of 9 Answers

malli434

  • Jan 2nd, 2009
 

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;

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions