How can I exp the data where my following query is true:

select d.deptno,dname,ename,sal,address from dept d,emp e where
d.deptno=e.deptno;

And Then how I imp the same data on client database in both tables.