select name.deptname.doj from emp_table innerjoin dept_table
on emp_table.deptno = dept_table.deptno

Select...........
from....
........
where DEPT_TABLE.DEPNO = EMP_TABLE.DEPNO.
AND DOJ  between '01/01/2007' and '01/01/2008'

Try this if wrong let me know...

SELECT A.NAME
      ,A.DEPTNAME 
      ,B.DOJ
FROM  EMP_TABLE A 
     ,DEPT_TABLE.EMP_TABLE B 
WHERE A.DEPTNO = B.DEPTNO
  AND B.DOJ BETWEEN '01-01-2007' AND '01-01-2008'
;

select e.name,e.deptname,d.doj from emp_table e,dept_table d
where e.deptno=d.deptno and doj between '01-jan-2007' and
'01-jan-2008'

Select a.Name,a.DeptName,b.doj From Emp_Table as 
a,Dept_Table as b Where a.Deptno=b.deptno and b.doj 
between '01-jan-2007' And '01-jan-2008'