General :: Transferring Data From Table To Another Under Conditions

I have 3 tables :

table 1 empno Employee Nomber
empname Employee name
salary basic Salary
bonus
deduction
iddate month nomber

table 2 is bonus table id
empno
bonus amount
iddate

table 3 is deduction tableid
empno
deduction amount
iddate

Now i need is to transfer the data from bonus table and from deduction table to the table 1 if the empno and iddate are equal on the both tables

What I mean for ex if i create query and when i enter the employee number directly it will give me his bonus if he has and his deduction also if he has, so how can i do it?