INSERT INTO salesClientUnitStateHistory ( idSalesClientUnit, idSalesClientState, idEmployee, dateRegistration ) VALUES ( , , , ) ON DUPLICATE KEY UPDATE dateRegistration= Details: " & cfcatch.Detail> SELECT salesClientUnitStateHistory.idSalesClientUnit, salesClientUnitStateHistory.idSalesClientState, salesClientState.name AS salesClientState, salesClientUnitStateHistory.idEmployee, CONCAT(TRIM(CONCAT(employee.nameFirst, ' ', employee.nameFirst1)), ' ', TRIM(CONCAT(employee.nameLast, ' ', employee.nameLast1))) AS employee, salesClientUnitStateHistory.dateRegistration FROM salesClientUnitStateHistory LEFT JOIN salesClientState ON salesClientUnitStateHistory.idSalesClientState=salesClientState.idSalesClientState LEFT JOIN employee ON salesClientUnitStateHistory.idEmployee=employee.idEmployee WHERE salesClientUnitStateHistory.idSalesClientUnit= AND salesClientUnitStateHistory.idSalesClientState= ORDER BY salesClientUnitStateHistory.dateRegistration DESC LIMIT 0,1