Select Failed. 3706: Syntax error: expected something between '=' and the end of the request

Analytics
Highlighted

Select Failed. 3706: Syntax error: expected something between '=' and the end of the request

Can someone help resolve this: I receive "Select Failed. 3706: Syntax error: expected something between '=' and the end of the request" for the following query:

 

 

2 REPLIES
Teradata Employee

Re: Select Failed. 3706: Syntax error: expected something between '=' and the end of the request

There is a & before query_date  in the second unioned query which is causing this issue. 

You will also get an error for not naming the subquery and another for the != in the last having clause , Teradata uses <> instead

 

 

Good luck!

Re: Select Failed. 3706: Syntax error: expected something between '=' and the end of the request

Thank you!