Ca donne une requête qui marche pas (2 virgules qui se suivent...)
SELECT DISTINCT T_SITE.INDICE_SITE, T_SITE.LIBELLE_SITE,,CONVERT(nchar, T_SITE.NUMERO_REFERENCE) + ' - ' + CONVERT(nchar,T_SITE.LIBELLE_SITE) + ' - ' + CONVERT(nchar,T_ORGANE.LIBELLE_ORGANE) as SITE_ORGANE,CONVERT(nchar,T_SITE.INDICE_SITE) + ' - ' + CONVERT(nchar,T_COM.INDICE_COM) as SITE_COM from T_COM,T_SITE,T_SITE_COM,T_VAR_VALEUR,T_VARIABLE,T_VARIABLE_LIBELLE,T_ORGANE where T_VARIABLE_LIBELLE.INDICE_TABLE_VAR=7 and T_COM.INDICE_ORGANE=T_ORGANE.INDICE_ORGANE
Partager