DATA Step, Macro, Functions and more

Error in sql query

Reply
New Contributor
Posts: 2

Error in sql query

Hi,

 

I'm getting following error: Syntax error: expected something between the 'and' keyword and the 'month' keyword. 

 

Code:

select a.*, b.* from table1 a inner join table2 b 

on a.client = b.client AND month(a.date1) = month(b.date2);

Super User
Posts: 5,825

Re: Error in sql query

Posted in reply to maverick123

Please share the full log.

Data never sleeps
New Contributor
Posts: 2

Re: Error in sql query

 SELECT
 a.*,  b.*
 FROM table1 a
 INNER JOIN table2 b
 ON a.client = b.client and month(b.trans_dt) = month(a.cycle_dt)

ERROR: Teradata prepare: Syntax error: expected something between the 'and' keyword and the 'month' keyword.

Super User
Posts: 22,823

Re: Error in sql query

Posted in reply to maverick123

Post your full code and log. 

 

If you're using SQL Pass Thru then you need to be using Teradata functions, where MONTH() may not be a Teradata function. 

 


maverick123 wrote:

 SELECT
 a.*,  b.*
 FROM table1 a
 INNER JOIN table2 b
 ON a.client = b.client and month(b.trans_dt) = month(a.cycle_dt)

ERROR: Teradata prepare: Syntax error: expected something between the 'and' keyword and the 'month' keyword.


 

Ask a Question
Discussion stats
  • 3 replies
  • 160 views
  • 0 likes
  • 3 in conversation