1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65
|
INSERT
INTO tbl_marche_ase
SELECT COLECT,
UAGTHEM,
ANBU1,
NUBU1,
NNM1,
PERIODE1,
PART1,
SUBSTR(NNM1,3,2),
FOUR,
UAU,
MTMINI,
MTMAXI,
MTINIT,
MTAVE,
MTVARI,
TOT,
MTPART,
CREAL,
MT,
CLIQ,
CMAN,
DLIQ,
RESENG,
DLRE,
DATMAN,
NMAND,
MANDARC,
OBJET,
LIEU,
OBS,
TYPMAR,
TYPERIOD,
VALIDITE,
NATMAR,
SECTBU,
CAO,
DATNOTI,
DATDEB,
DATEJLIM,
DATSOLDE,
DATEJ,
NUMENG,
LIGNE,
MILLESI,
DATECAO,
DATFINMA,
INTERFACE,
ARTICLE,
NNMIXTE,
TYPACHAT,
TXIM,
DLGP,
PROCDART,
NDB,
T2
FROM SAGA_MARCHE
WHERE COLECT = 'V'
AND ANBU1 = '07'
AND VALIDITE = 'V'
AND nnm1 NOT IN ( SELECT code_marche_national
FROM marche
WHERE code_marche_national IS NOT NULL ); |
Partager