Skip to Content
0
Nov 03, 2012 at 09:05 AM

SQL Syntax error

36 Views

Hi,

Please help resolve the syntax error.

I want to do a self join to do a calculation, but am getting the following syntax error.

MDXRuntime: Internal deployment of object failed: Internal Error:Deploy Calculation View: SQL: sql syntax error: incorrect syntax near ".": line 2 col 55

Please help me correct it.

Followign is the code i am writing-

BEGIN

var_out = select t1.sl_no from t1 as "_SYS_BIC"."spack/TEST"

join t2 as "_SYS_BIC"."spack/TEST"

on t1.sl_no = t2.sl_no;

Thanks in Advance!

Regards,

Rathy