SELECT *
FROM p_acte
WHERE codeActe NOT IN (SELECT codeActe FROM actesbaremepriseencharge)




DROP TEMPORARY TABLE IF EXISTS actesbaremepriseencharge_rattapage;	 
CREATE TEMPORARY TABLE actesbaremepriseencharge_rattapage
SELECT DISTINCT idBaremePriseEnCharge, codeProduit, codeGarantie, codeActe FROM actesbaremepriseencharge;



SELECT *
FROM p_acte
WHERE codeActe NOT IN (SELECT codeActe FROM actesbaremepriseencharge_rattapage)




DROP TEMPORARY TABLE IF EXISTS actesbaremepriseencharge_rattapage;	