INSERT INTO MYSQL_T_ANOUVEAUX(CLT_ID, EXCPTA_ID, CCPT_ID, MT_DEB, MT_CRED, SCENARIO) SELECT EXER.EXCPTA_CLT_ID, EXCPTA_ID, CCPT_ID, 0 as MT_DEB, 0 as MT_CRED, 0 as SCENARIO FROM MYSQL_T_COMPTE_CPTA CPTE INNER JOIN MYSQL_T_CLT_EXER_CPTA EXER ON( EXER.EXCPTA_CLT_ID = CPTE.CLT_ID OR CPTE.CLT_ID=0 ) WHERE CPTE.CCPT_ID>9 AND EXER.EXCPTA_CLT_ID =? AND EXCPTA_ID=? ORDER BY CLT_ID, CCPT_ID ASCINSERT INTO MYSQL_T_ANOUVEAUX(CLT_ID, EXCPTA_ID, CCPT_ID, MT_DEB, MT_CRED, SCENARIO) SELECT EXER.EXCPTA_CLT_ID, EXCPTA_ID, CCPT_ID, 0 as MT_DEB, 0 as MT_CRED, 0 as SCENARIO FROM MYSQL_T_COMPTE_CPTA CPTE INNER JOIN MYSQL_T_CLT_EXER_CPTA EXER ON( EXER.EXCPTA_CLT_ID = CPTE.CLT_ID OR CPTE.CLT_ID=0 ) WHERE CPTE.CCPT_ID>9 AND EXER.EXCPTA_CLT_ID =? AND EXCPTA_ID=? ORDER BY CLT_ID, CCPT_ID ASC