hi pedro
this is a special recursive syntax for sql query

no matter, the problem came from a comment character in the query that was not well interpreted by Talend

thanks

Hi pedro
thanks for the answer but it doesn't work better.

The sql request seams not to be propely interpreted by Talend :

Exception in thread "main" java.lang.Error: Problèmes de compilation non résolus :
    Erreur de syntaxe sur le sème "T", ; attendu
    Erreur de syntaxe sur le sème "V_CEREXTRADIMTREES", supprimez ce sème
    Erreur de syntaxe, insérez ";" pour effectuer Instruction
    Erreur de syntaxe, insérez ")" pour effectuer MethodInvocation
    Erreur de syntaxe, insérez ")" pour effectuer MethodInvocation

the query bebins as :
WITH T AS
(
    SELECT * FROM
    (
        SELECT V_CEREXTRADIMTREES.dim_id,code,dim_desc,lng
        FROM V_CEREXTRADIMTREES V_CEREXTRADIMTREES
        WHERE (V_CEREXTRADIMTREES.ows IN (0, 222071, 222081))
        AND (V_CEREXTRADIMTREES.dimension_id IN (10012))


is there a limit for the complexity of sql syntax?
What is the driver used by Talend ?

Thanks for help

regards

Hi

I have this error message when lauching my job :

Exception in component tMSSqlInput_1
java.sql.SQLException: Incorrect syntax near ','.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)

The request is very long and complex but works properly in SQL Server Management Studio and retrieves the right data.
It begins as :

WITH T AS(SELECT * FROM (  SELECT V_CEREXTRADIMTREES.dim_id,code,dim_desc,lng  FROM V_CEREXTRADIMTREES V_CEREXTRADIMTREES  WHERE (V_CEREXTRADIMTREES.ows IN (0, 222071, 222081)) AND ...

an idea ?
a jdbc or driver problem?

Thanks for help