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 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85
| SELECT [MOIS]
,[AC_K1]
,[AC_Z]
,[ANV4]
,[SUB_BDD]
,[SANV6]as [ANV6]
,[SANV5]as [ANV5]
,[SANV4]as [ANV4]
,[SANV3]
,[STRUCTURE]
,[GESTION6]
,[GESTION5]
,[GESTION4]
,[GESTION3]
,[GESTION2]
,[ORG_D]
,[PN3]
,[PHI]
,[P2]
,[CONTROL]
,[P3]
,[P2]
,[P1]
,[RÉPÈRE]
,[ARGENT]
, Null as [RAISON]
, Null as [C_PO]
, Null as [CIM]
, Null as [EXTERNE]
, Null as [GESTIOMOIS]
, Null as [EXTERCA]
, Null as [COMM_MOIS]
, Null as [REEL]
, Null as [ERRO]
, Null as [ERROM]
, Null as [EFM]
, Null as [FMM
, Null as [CMACTU]
,Null as [CMACTU-1]
FROM Table1
UNION
SELECT [MOIS]
,[RAISON]
,[ANV4]
,[ANV5]
,[ANV6]
,[AC_Z]
,[C_PO]
,[PN3]
,[PHI]
,[GESTION2]
,[GESTION3]
,[GESTION4]
,[GESTION5]
,[GESTION6]
,[CIM]
,[EXTERNE]
,[GESTIOMOIS]
,[EXTERCA]
,[COMM_MOIS]
,[REEL]
,[ERRO]
,[ERROM]
,[EFM]
,[FMM
,[CMACTU]
,[CMACTU-1]
,Null as[P2]
, Null as [CONTROL]
, Null as [P3]
, Null as [P2]
, Null as [P1]
, Null as [RÉPÈRE]
, Null as [ARGENT]
, Null as [AC_K1]
, Null as [ORG_D]
, Null as [SUB_BDD]
, Null as [SANV3]
, Null as [STRUCTURE]
, Null as [ANV4]
FROM Table2 |
Partager