Bonjour pgz,
J'ai corrigé mon texte dont voici le résultat:
SELECT T_PARTDESC.PDPNUM, T_PARTDESC.PDLANG, STRIP(T_PARTDESC.PDPNUM) CONCAT T_PARTDESC.PDLANG, T_PARTDESC.PDPDES, T_PARTMASTER.PAPDES, T_PARTMASTER.PASCSU, T_PARTMASTER.PAACTF, T_PARTMASTER.PAPCLS FROM TAD.ECDSCP AS T_PARTDESC INNER JOIN TAD.ECARTP AS T_PARTMASTER ON T_PARTDESC.PDPNUM = T_PARTMASTER.PAPNUM WHERE T_PARTDESC.PDCONO ='EC' AND T_PARTMASTER.PASGRP = 'AB23' AND T_PARTDESC.PDPDES <>'' ORDER BY T_PARTDESC.PDPNUM, T_PARTDESC.PDLANG
Malheureusement, j'ai toujours une erreur -2147467259
SQL0104:Token SELECT T_PARTDESC.PDPNUM, T_P was not valid. Valid tokens: ( END GET SET CALL DROP FREE HOLD...
Partager