Syntax error 3706

General

Syntax error 3706

Hi Everyone,

I am new to this forum as well as to teradata.. I am getting  this error while trying to execute the query. Please help me to resolve.

((select    a11.coulmn  col1,

        sum(a11.Salesamount) ,

        sum(a11.Salesamountlocal)

    from    Table. a11

    group by    a11.col1

    )  pa11

    join    Table a.13

      on     (pa11.col1 = a13.col1))

error : Expected something between the word 'col1' and ')'

1 REPLY

Re: Syntax error 3706

 

is this the full query,  this appears to be only part of the query. is there a from clause prior to the initial bracket. The above query should work fine. you cannot start the query with a bracket

sel * from

((select   a11.coulmn  col1,

        sum(a11.Salesamount) ,

        sum(a11.Salesamountlocal)

    from databasename.a11 a11

    group by   a11.col1

    )  pa11

    join  dbname .a13 a13

      on   (pa11.col1 = a13.col1))