topic Re: Error in sql query in SAS Programming

Error in sql query

maverick123 — Sat, 03 Feb 2018 08:32:06 GMT

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

Re: Error in sql query

LinusH — Sat, 03 Feb 2018 09:09:44 GMT

Please share the full log.

Re: Error in sql query

maverick123 — Sat, 03 Feb 2018 17:29:00 GMT

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.

Re: Error in sql query

Reeza — Sat, 03 Feb 2018 20:42:54 GMT

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.