Joins are used to join different tables
for about joins follow this link
create table deptwisesal(deptno number(2),sal number(5));


insert into deptwisesal select d.deptno,e.sal from emp e,dept d where e.deptno=d.deptno and e.sal>1000


drop table deptwisesal;