I have a sqlite table like this: id name mnote 7 DDD_POSTE_DE_COND 2;AA35469850.1;DDD;ECRHEMBNETM6X100AC8Z;000 2;7903233029.1;;AA35469850.1;DDD;ECRHEMBNETM6X100AC8Z;000 3;9807260277.1;;AA36766417.1;DDD;COMMU-REGU-LIMI-VITE;001 4;9665586177.1;;AA36284384.1;DDD;COMMU-REGU-LIMI-VITE;001 5;9675673177.1;;AA36049484.1;DDD;BLOC-COMMU-COMM-BVMP;003 6;9663123380.1;;AA35651299.1;DDD;ANTENN-ELECTR-TRANSP;001DDD_POSTE_DE_COND
8 ASSISE-BASSE AA34695081 14;9807054180.1;;AA36305186.1;DDD;BOITIE-SERVIT-INTELL;002 15;9801195980.1;;AA37380334.1;DDD;SUPPOR-BOITIE-SERVIT;000 16;9805077080.1;;AA36701967.1;DDD;BOITIE-COMMAN-CLIMAT;003 17;9804790880.1;;AA36696339.1;DDD;CAPT-DET-CHO-MOY-RET;001 18;9804790880.1;;AA36696338.1;DDD;CAPT-DET-CHO-MOY-RET;001 9 FAISCEAUX-ELEC-PDC 1;9807698080.1;;AA35538582.1;DDD;GOUT-TAB-INF-FAI-HAB;000 2;9803453480.1;;AA35574764.1;DDD;GOUTT-TUNN-FAIS-HABI;000 3;9803453480.1;;AA35538573.1;DDD;GOUTT-TUNN-FAIS-HABI;000 4;9681595580.1;;AA36168981.1;DDD;ECR-HXEMBBOR5X160PLA;002 5;9681595580.2;;AA36168981.1;DDD;ECR-HXEMBBOR5X160PLA;002 6;967352338A.1;;AA35568067.1;DDD;MODU-LOC-ALA-ANT-VOL;004 I want to merge all the mnote, how to do this? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users