1 2 3
| SELECT SYNTHESE_MAILLES_SCORES.NBESPECES, SYNTHESE_MAILLES_SCORES.NBDONNEES, SYNTHESE_MAILLE_ESPECES_TCD.IDMAILLE, IIf([Aeshna affinis] Is Not Null,"Aeshna affinis (" & [Aeshna affinis] & ")<br>","") & IIf([Aeshna cyanea] Is Not Null,"Aeshna cyanea (" & [Aeshna cyanea] & ")<br>","") & IIf([Aeshna grandis] Is Not Null,"Aeshna grandis (" & [Aeshna grandis] & ")<br>","") & IIf([Aeshna isoceles] Is Not Null,"Aeshna isoceles (" & [Aeshna isoceles] & ")<br>","") & IIf([Aeshna mixta] Is Not Null,"Aeshna mixta (" & [Aeshna mixta] & ")<br>","") & IIf([Anax imperator] Is Not Null,"Anax imperator (" & [Anax imperator] & ")<br>","") & IIf([Anax parthenope] Is Not Null,"Anax parthenope (" & [Anax parthenope] & ")<br>","") & IIf([Boyeria irene] Is Not Null,"Boyeria irene (" & [Boyeria irene] & ")<br>","") & IIf([Brachytron pratense] Is Not Null,"Brachytron pratense (" & [Brachytron pratense] & ")<br>","") & IIf([Calopteryx splendens] Is Not Null,"Calopteryx splendens (" & [Calopteryx splendens] & ")<br>","") & IIf([Calopteryx virgo] Is Not Null,"Calopteryx virgo (" & [Calopteryx virgo] & ")<br>","") & IIf([Ceriagrion tenellum] Is Not Null,"Ceriagrion tenellum (" & [Ceriagrion tenellum] & ")<br>","") & IIf([Chalcolestes viridis] Is Not Null,"Chalcolestes viridis (" & [Chalcolestes viridis] & ")<br>","") & IIf([Coenagrion mercuriale] Is Not Null,"Coenagrion mercuriale (" & [Coenagrion mercuriale] & ")<br>","") & IIf([Coenagrion puella] Is Not Null,"Coenagrion puella (" & [Coenagrion puella] & ")<br>","") & IIf([Coenagrion pulchellum] Is Not Null,"Coenagrion pulchellum (" & [Coenagrion pulchellum] & ")<br>","") & IIf([Coenagrion scitulum] Is Not Null,"Coenagrion scitulum (" & [Coenagrion scitulum] & ")<br>","") & IIf([Cordulegaster boltonii] Is Not Null,"Cordulegaster boltonii (" & [Cordulegaster boltonii] & ")<br>","") & IIf([Cordulia aenea] Is Not Null,"Cordulia aenea (" & [Cordulia aenea] & ")<br>","") & IIf([Crocothemis erythraea] Is Not Null,"Crocothemis erythraea (" & [Crocothemis erythraea] & ")<br>","") & IIf([Enallagma cyathigerum] Is Not Null,"Enallagma cyathigerum (" & [Enallagma cyathigerum] & ")<br>","") & IIf([Erythromma lindenii] Is Not Null,"Erythromma lindenii (" & [Erythromma lindenii] & ")<br>","") & IIf([Erythromma najas] Is Not Null,"Erythromma najas (" & [Erythromma najas] & ")<br>","") & IIf([Erythromma viridulum] Is Not Null,"Erythromma viridulum (" & [Erythromma viridulum] & ")<br>","") & IIf([Gomphus pulchellus] Is Not Null,"Gomphus pulchellus (" & [Gomphus pulchellus] & ")<br>","") & IIf([Gomphus simillimus] Is Not Null,"Gomphus simillimus (" & [Gomphus simillimus] & ")<br>","") & IIf([Gomphus vulgatissimus] Is Not Null,"Gomphus vulgatissimus (" & [Gomphus vulgatissimus] & ")<br>","") & IIf([Hemianax ephippiger] Is Not Null,"Hemianax ephippiger (" & [Hemianax ephippiger] & ")<br>","") & IIf([Ischnura elegans] Is Not Null,"Ischnura elegans (" & [Ischnura elegans] & ")<br>","") & IIf([Ischnura pumilio] Is Not Null,"Ischnura pumilio (" & [Ischnura pumilio] & ")<br>","") & IIf([Lestes barbarus] Is Not Null,"Lestes barbarus (" & [Lestes barbarus] & ")<br>","") & IIf([Lestes dryas] Is Not Null,"Lestes dryas (" & [Lestes dryas] & ")<br>","") & IIf([Lestes sponsa] Is Not Null,"Lestes sponsa (" & [Lestes sponsa] & ")<br>","") & IIf([Lestes virens] Is Not Null,"Lestes virens (" & [Lestes virens] & ")<br>","") & IIf([Leucorrhinia pectoralis] Is Not Null,"Leucorrhinia pectoralis (" & [Leucorrhinia pectoralis] & ")<br>","") & IIf([Libellula depressa] Is Not Null,"Libellula depressa (" & [Libellula depressa] & ")<br>","") & IIf([Libellula fulva] Is Not Null,"Libellula fulva (" & [Libellula fulva] & ")<br>","") & IIf([Libellula quadrimaculata] Is Not Null,"Libellula quadrimaculata (" & [Libellula quadrimaculata] & ")<br>","") & IIf([Onychogomphus forcipatus] Is Not Null,"Onychogomphus forcipatus (" & [Onychogomphus forcipatus] & ")<br>","") & IIf([Onychogomphus uncatus] Is Not Null,"Onychogomphus uncatus (" & [Onychogomphus uncatus] & ")<br>","") & IIf([Orthetrum albistylum] Is Not Null,"Orthetrum albistylum (" & [Orthetrum albistylum] & ")<br>","") & IIf([Orthetrum brunneum] Is Not Null,"Orthetrum brunneum (" & [Orthetrum brunneum] & ")<br>","") & IIf([Orthetrum cancellatum] Is Not Null,"Orthetrum cancellatum (" & [Orthetrum cancellatum] & ")<br>","") & IIf([Orthetrum coerulescens] Is Not Null,"Orthetrum coerulescens (" & [Orthetrum coerulescens] & ")<br>","") & IIf([Oxygastra curtisii] Is Not Null,"Oxygastra curtisii (" & [Oxygastra curtisii] & ")<br>","") & IIf([Platycnemis acutipennis] Is Not Null,"Platycnemis acutipennis (" & [Platycnemis acutipennis] & ")<br>","") & IIf([Platycnemis pennipes] Is Not Null,"Platycnemis pennipes (" & [Platycnemis pennipes] & ")<br>","") & IIf([Pyrrhosoma nymphula] Is Not Null,"Pyrrhosoma nymphula (" & [Pyrrhosoma nymphula] & ")<br>","") & IIf([Somatochlora flavomaculata] Is Not Null,"Somatochlora flavomaculata (" & [Somatochlora flavomaculata] & ")<br>","") & IIf([Somatochlora metallica] Is Not Null,"Somatochlora metallica (" & [Somatochlora metallica] & ")<br>","") & IIf([Sympecma fusca] Is Not Null,"Sympecma fusca (" & [Sympecma fusca] & ")<br>","") & IIf([Sympetrum danae] Is Not Null,"Sympetrum danae (" & [Sympetrum danae] & ")<br>","") & IIf([Sympetrum flaveolum] Is Not Null,"Sympetrum flaveolum (" & [Sympetrum flaveolum] & ")<br>","") & IIf([Sympetrum fonscolombii] Is Not Null,"Sympetrum fonscolombii (" & [Sympetrum fonscolombii] & ")<br>","") & IIf([Sympetrum meridionale] Is Not Null,"Sympetrum meridionale (" & [Sympetrum meridionale] & ")<br>","") & IIf([Sympetrum pedemontanum] Is Not Null,"Sympetrum pedemontanum (" & [Sympetrum pedemontanum] & ")<br>","") & IIf([Sympetrum sanguineum] Is Not Null,"Sympetrum sanguineum (" & [Sympetrum sanguineum] & ")<br>","") & IIf([Sympetrum striolatum] Is Not Null,"Sympetrum striolatum (" & [Sympetrum striolatum] & ")<br>","") & IIf([Sympetrum vulgatum] Is Not Null,"Sympetrum vulgatum (" & [Sympetrum vulgatum] & ")<br>","") AS SYNTHESE INTO SYNTHESE_MAILLES_TBL_2015
FROM SYNTHESE_MAILLE_ESPECES_TCD INNER JOIN SYNTHESE_MAILLES_SCORES ON SYNTHESE_MAILLE_ESPECES_TCD.IDMAILLE = SYNTHESE_MAILLES_SCORES.IDMAILLE
ORDER BY SYNTHESE_MAILLE_ESPECES_TCD.IDMAILLE; |
Partager