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