1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| select
(LFTA_elongation OR LFTA_infiltration OR LFTA_epaississement)*-1 as xLFTA,
LFTA*-1 as nLFTA,
LTFA_elongation*-1 as nLTFA_elongation,
LFTA_infiltration*-1 as nLFTA_infiltration,
LTFA_epaississement*-1 as nLTFA_epaississement,
(LCF_discontinuite OR LCF_liquide OR LCF_arrachement OR LCF_distension)*-1 as xLCF,
LCF*-1 as nLCF,
LCF_discontinuite*-1 as nLCF_discontinuite,
LCF_liquide*-1 as nLCF_liquide,
LCF_arrachement*-1 as nLCF_arrachement,
LCF_distension*-1 as nLCF_distension,
(LLI_superficiel OR LLI_profond OR LLI_arrachement)*-1 as xLLI,
LLI*-1 as nLLI,
LLI_superficiel*-1 as nLLI_superficiel,
LLI_profond*-1 as nLLI_profond,
LLI_arrachement*-1 as nLLI_arrachement
from Table1 |
Partager