Syntax error, missing/misplaced FROM

[matfurrier]

Friends, do not know what happens in this case. I tried several ways and always presents the same error. What can this be?

Syntax error, missing/misplaced FROM:
LIMITECLIENTE:
LOAD
ACCOUNTNUM AS[Código do Cliente],
CREDITMAX AS [Limite Total],
ATUAL AS [Limite Atual]
LIMITECLIENTE:
LOAD
ACCOUNTNUM AS[Código do Cliente],
CREDITMAX AS [Limite Total],
ATUAL AS [Limite Atual]

Below is the code that I created.

LIMITECLIENTE:
LOAD
ACCOUNTNUM AS[Código do Cliente],
CREDITMAX AS [Limite Total],
ATUAL AS [Limite Atual];
SELECT 
CUSTTABLE.ACCOUNTNUM, 
CUSTTABLE.CREDITMAX,
(CUSTTABLE.CREDITMAX - ISNULL((SELECT SUM (TMPCRE.VALOR) FROM AX501_SRL_PROD2.dbo.TMPCRE  WHERE TMPCRE.ACCOUNT = CUSTTABLE.ACCOUNTNUM AND TMPCRE.STATUS = 'ABERTO'),0))ATUAL
FROM AX501_SRL_PROD2.dbo.CUSTTABLE;
STORE LIMITECLIENTE INTO ;
DROP TABLE LIMITECLIENTE

[Siva_Sankar]

use sql before the select keyword. LIMITECLIENTE: LOAD ACCOUNTNUM AS[Código do Cliente], CREDITMAX AS [Limite Total], ATUAL AS [Limite Atual]; sql SELECT CUSTTABLE.ACCOUNTNUM, CUSTTABLE.CREDITMAX, (CUSTTABLE.CREDITMAX - ISNULL((SELECT SUM (TMPCRE.VALOR) FROM AX501_SRL_PROD2.dbo.TMPCRE  WHERE TMPCRE.ACCOUNT = CUSTTABLE.ACCOUNTNUM AND TMPCRE.STATUS = 'ABERTO'),0))ATUAL FROM AX501_SRL_PROD2.dbo.CUSTTABLE; STORE LIMITECLIENTE INTO ; DROP TABLE LIMITECLIENTE regards. siva

[hic · Accepted solution]

You need a space between AS and [Código do Cliente]

HIC

[matfurrier]

Friends, you are great!

Both answers helped me!

Thank you.

Hugs!