I need to create a UPDATE query eihter as a stored query or an RUNSQL string.
It's a attendance system:
I have a select query that shows ceratin records for date_id, in, out, employee_id.
I have a table with existing records of the same structure.
I need to update the table with records from the query where the date_id is the key.