SELECT refpanier FROM commandes<br>(813817,827830,173179400,665668,593594,584831948,424425,83252292,389393,315317,868872,392394)<br>**********IN ************<br>SELECT * FROM panierarticle WHERE refpanier IN (813817,827830,173179400,665668,593594,584831948,424425,83252292,389393,315317,868872,392394)<br>584831948 servlang11<br>584831948 bavpoul02<br>593594 couslang03<br>813817 drapbain01<br>813817 drapbain02<br>813817 servlang03<br>813817 bavcol07<br>173179400 fanionrond08<br>173179400 servlang16<br>593594 servlang11<br>593594 fanionrond06<br>593594 fanionrond07<br>665668 servlang08<br>827830 servlang09<br>665668 fanionrond02<br>424425 espacev01<br>424425 espacev21<br>424425 espacev33<br>424425 espacev37<br>424425 espacev34<br>83252292 espacev05<br>424425 espacev05<br>868872 espacev34<br>83252292 espacev13<br>83252292 espacev14<br>389393 espacev12<br>315317 espacev16<br>315317 espacev12<br>315317 espacev20<br>868872 espacev31<br>392394 espacev04<br>392394 espacev03<br>********** liste des couples panier-article ne correspondant à aucune commande ************<br>SELECT * FROM panierarticle WHERE refpanier NOT IN (813817,827830,173179400,665668,593594,584831948,424425,83252292,389393,315317,868872,392394)<br>DELETE FROM panierarticle WHERE refpanier NOT IN (813817,827830,173179400,665668,593594,584831948,424425,83252292,389393,315317,868872,392394)<br><br><font color=red></font><br>