1 2 3 4 5 6 7 8 9 10
| select critere_cleunik,critere_code,critere_denomination,case critere_actif WHEN 1 THEN 'Actif' ELSE 'Inactif' END AS critere_actif,
critere_portee,
IF (critere_portee & 1,'Oui','Non') as portee_entreprise,
IF (critere_portee & 2,'Oui','Non') as portee_prospect_client,
IF (critere_portee & 4,'Oui','Non') as portee_client,
IF (critere_portee & 8,'Oui','Non') as portee_prospect_fournisseur,
IF (critere_portee & 16,'Oui','Non') as portee_fournisseur,
IF (critere_portee & 32,'Oui','Non') as portee_autre_acteur,
IF (critere_portee & 64,'Oui','Non') as portee_acteur_indeterminé
from _criteres where critere_cleunik >9999 and critere_portee &127 |
Partager