Hi,

Is use a virutalQuery to show informations :

1.

SELECT A.INT_COUT,A.MAT_ID,A.INT_DEB,A.INT_TECH,CAST(SUBSTR(A.INT_DESC,0,255) AS VARCHAR(255)) AS INT_DESC_T,CAST(SUBSTR(A.INT_ACT,0,255) AS VARCHAR(255)) AS INT_ACT_T,A.INT_FIN,A.INT_TYPE,(B.T_CIVILITE || ' ' || B.T_PRENOM || ' ' || B.T_NOM) AS CONTACT,C.LTI_LIBELLE FROM T_INTER_MATERIEL A,L_TECHNICIEN B,L_TYPE_INTM C WHERE (A.INT_TECH = B.T_ID) AND (A.INT_TYPE = C.LTI_ID) AND (A.MAT_ID = 97) AND (INT_FIN IS NULL) ORDER BY A.INT_DEB DESC,A.INT_FIN DESC

2.

SELECT A.INT_COUT,A.MAT_ID,A.INT_DEB,A.INT_TECH,CAST(SUBSTR(A.INT_DESC,0,255) AS VARCHAR(255)) AS INT_DESC_T,CAST(SUBSTR(A.INT_ACT,0,255) AS VARCHAR(255)) AS INT_ACT_T,A.INT_FIN,A.INT_TYPE,(B.T_CIVILITE || ' ' || B.T_PRENOM || ' ' || B.T_NOM) AS CONTACT,C.LTI_LIBELLE FROM T_INTER_MATERIEL A,L_TECHNICIEN B,L_TYPE_INTM C WHERE (A.INT_TECH = B.T_ID) AND (A.INT_TYPE = C.LTI_ID) AND (A.MAT_ID = 97) AND (NOT (INT_FIN IS NULL)) ORDER BY A.INT_DEB DESC,A.INT_FIN DESC

The query number 2 work but le number 1 do not show any data, if y done the same query with uniquery (postgres) it works

any ideas ?

thanks