SQL Editor issue - NFD/NFC

[SDeora]

Hello, Struggling with this once since a couple of days. tried removing the spaces / adding spaces but nothing seems to work - considering the query works fine in Teradata... please help! 

SEL GL_ACCOUNT_CODE, COMPANY_CODE, PROFIT_CENTER_CODE, MRC_CODE, FISCAL_YEAR, FISCAL_YEAR_PERIOD_NUMBER, SRC_SYS_ID, SUM (MRC_MTD_AMOUNT), SUM (MRC_YTD_AMOUNT), SUM (MRC_YTD_AMOUNT), SUM (LOCAL_MTD_AMOUNT), SUM (LOCAL_YTD_AMOUNT)
FROM FPR_V.PRJ_FACT_SALES_COGS_BAL_PLAN
WHERE SRC_SYS_ID = 'ABCD'
AND FISCAL_YEAR = 2020
GROUP BY 1,2,3,4,5,6,7
ORDER BY 1,2,3,4,5,6;

[joshuaburkhow]

Hi @SDeora 

There are a few things to check. Most of them are here https://community.alteryx.com/t5/Alteryx-Designer-Discussions/In-Database-Error-The-object-name-is-t...

Might be the spaces....

[SDeora]

Thanks but I'm unable to open the link... 😞 it says invalid parameters. 

[MarqueeCrew · Accepted solution]

@SDeora ,

@joshuaburkhow 's link should be:  https://community.alteryx.com/t5/Alteryx-Designer-Discussions/In-Database-Error-The-object-name-is-t... 

As for the select statement, what type of time savings does Teradata achieve by shortening SELECT to SEL?  I'd change that if for no other reason that it is too terse for me.

Cheers,

Mark

[SDeora]

SEL to Select seems to have worked for me ! Thanks!!! 

[csh8428]

@MarqueeCrew 's advise to change "sel" to "select" also worked for me.