Qlik View Load SQL Select Question

[#1]

Hi,

Look at below two script:

Load A, B；

SQL Select field1 as A, filed as B from Table；

The result is cannot find the filed A；

But another one is

Load *；

SQL Select field1 as A, filed as B from Table；

This works, I am a bit confused why？？？

[maxgro]

is "A" or "a" available?

which database are you using? I tried on an Oracle dbms with ODBC and both your script works