Error in sql query

[maverick123]

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);

[LinusH]

Please share the full log.

[maverick123]

 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.

[Reeza]

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.

---