UPDATE 	adherentbascule	SET codeGcAssureur='ARTUS' WHERE idPolice  IN (66,67,80);

UPDATE 	carteassuretest	SET codeGcAssureur='ARTUS' WHERE idPolice  IN (66,67,80);
UPDATE 	college	SET codeGcAssureur='ARTUS' WHERE idPolice  IN (66,67,80);
UPDATE 	college_ren_temp	SET codeGcAssureur='ARTUS' WHERE idPolice  IN (66,67,80);
UPDATE 	college_temp	SET codeGcAssureur='ARTUS' WHERE idPolice  IN (66,67,80);
UPDATE 	collegelienparente	SET codeGcAssureur='ARTUS' WHERE idPolice  IN (66,67,80);
UPDATE 	collegelienparente_temp	SET codeGcAssureur='ARTUS' WHERE idPolice  IN (66,67,80);
UPDATE 	d_police	SET codeGcAssureur='ARTUS' WHERE id  IN (66,67,80);
UPDATE 	gc_carte_temp_non_sel	SET codeGcAssureur='ARTUS' WHERE idPolice  IN (66,67,80);
UPDATE 	gc_carte_temp_sel	SET codeGcAssureur='ARTUS' WHERE idPolice  IN (66,67,80);
UPDATE 	gc_facture	SET codeGcAssureur='ARTUS' WHERE idPolice  IN (66,67,80);
UPDATE 	gc_facture_temp_non_sel	SET codeGcAssureur='ARTUS' WHERE idPolice  IN (66,67,80);
UPDATE 	gc_facture_temp_sel	SET codeGcAssureur='ARTUS' WHERE idPolice  IN (66,67,80);
UPDATE 	gc_fraisgestion	SET codeGcAssureur='ARTUS' WHERE idPolice  IN (66,67,80);
UPDATE 	gc_h_police	SET codeGcAssureur='ARTUS' WHERE idPolice  IN (66,67,80);
UPDATE 	hpolice	SET codeGcAssureur='ARTUS' WHERE id  IN (66,67,80);
UPDATE 	police	SET codeGcAssureur='ARTUS' WHERE id  IN (66,67,80);



-- select * from hpolice 66,67,80


SELECT p.codeGcAssureur,p.* FROM police p WHERE p.numeroPolice IN ('21000034','21000021','21000020')


SELECT p.codeGcAssureur,p.* FROM police p WHERE p.idClient IN ('53')
