Symptom
Use of a column alias in a subquery fails with error 156
Example:
Msg 156, Level 15, State 68:
Server 'STEFANKXP', Line 4:
Incorrect syntax near the keyword 'AS'.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE)
Product
SAP Adaptive Server Enterprise all versions
Keywords
column alias, subquery , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview