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 (RFIDEmpID) SELECT TagIDEmpID 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?

Amit Gupta · Answer

Hope I understood your query you want to get the details from empTable and dbTable based on empid right? As insert query is as usual to fetch the details from multiple tables you need to use join like this SELECT empTable.empid empTable.firstname empTable.lastname empTable.tagid empTable.title dbTable.date dbTable.time FROM dbTable INNER JOIN empTable ON dbTable.empid = empTable.empid Do let me know if it was not

Amit Gupta · Answer

You can use count and group by clause to achieve this: SELECT COUNT(RFID) as TotalSwipe EmpID FROM dbTable GROUP BY EmpID For more reference visit http://www.w3resource.com/sql/aggregate-functions/count-with-group-by.php

Nazneen Sayed · Answer

not exactly amit RFID date time these fields will be saved into database at runtime continuously i need to know how many times in a day employee has swiped the card including his in and out timings and in between breaks thats why i am using Empid to identify which is that user since it is the only field unique here. so insert will be there as i need to save all the data with date and time.

Nazneen Sayed · Answer

there are two Tables EmpTable which have fields (EmpIDFirstnameLastnameTagIDTitle) and dbTable having Fields (RFIDEmpIDDateTime) now i need to save RFID (which is basically TAGID assigned to each Employee) and will be Swiped by user Number of times. the RFID mustt be saved with date time and empid(so that i can identify which employee has swiped the card as it is a primary key) need query for that.

Amit Gupta · Answer

Please share your table structure alongwith the required output.

Nazneen Sayed · Answer

i am getting this error : Column 'dbTable.RFID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. i dont need to count RFID.just save it into my dbTable and find associated EmpID of the card swiped From EMpTable.