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.
... View more
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);
... View more