inserting values of RFID and finding associated EMPID

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. 

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

 

Do let me know, if it was not 

there are two Tables EmpTable which have fields (EmpID,Firstname,Lastname,TagID,Title)

 

and dbTable having Fields (RFID,EmpID,Date,Time)

 

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. 

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.

You can use count and group by clause to achieve this:

 For more reference, visit

http://www.w3resource.com/sql/aggregate-functions/count-with-group-by.php