If you are using the script you have shown for getting data from database, meaning if this is a SQL script then kindly dont use the "As" key word, instead just keep one space and it will work.
Hi, yes ofcourse, I have build the application in 11.20 SR2 with a lot of alias, but yesterday we upgrade to 11.20 SR6.
All old alias was there and works fine, but when I try to add a new table into the model and use alias it dosent works.
Tested it with preceding loading a wildcard SQL statement and it works for me with SR6.
Maybe there is a problem, because you created the QVW with SR2.
Just try to copy and paste the whole script into a new QVW file.
Nevertheless, you should open a ticket at Qliktech support.
Try to write like two alias name and check
CorrespondenceType as TypeID,
Details as test
and check the two fields create with same fields or not.