inserting values of RFID and finding associated EMPID

Question

Hi,

 

i am trying to bulid an Attendance system project and need a Query for inserting values into my dbTable which has two FIelds RFID and EmpID.

the RFID Field can be saved multiple times and need to find EmpID associated each time card is swaped.

 

so far i have tried :

 

INSERT INTO dbTable (RFID,EmpID) SELECT TagID,EmpID FROM EmpTable

 

i dont see any results though. the RFID which will be number of times must be saved at rumtime and i want associated EmpID next to it so that i can identify which user swapped card how many times.

 

any suggestions?