Hi we are migrating databse from mssql to mysql.
i have a query in mssql like this
UPDATE CLK_DATA SET STATUS=3
WHERE CLIENT_ID=1 AND (PAYROLL=18440) AND (TYPE = 'OF')AND (CLK_TIME = (
FROM CLK_DATA WHERE CLIENT_ID=1 AND PAYROLL=18460)
when i try to execute this query i am getting below error message.
"You can't specify target table 'CLK_DATA' for update in FROM clause"
how do i solve this problem.
please do te need full