Symptom
A UNION query joining local and proxy tables may raise error 107 referencing a 'T1' prefix that is not used in the query.
1> SELECT B.col1 FROM p_tableB B
2> UNION
3> ( SELECT E.col1
4> FROM (select A1.col1 from tableA A1, p_tableE B1 where A1.col1 = B1.col1) E )
5> go
Msg 107, Level 15, State 1:
Server '<remote ASE name>', Line 1:
The column prefix 'T1' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a
correlation name which must be used instead.
Msg 107, Level 15, State 1:
Server '<remote ASE name>', Line 1:
The column prefix 'T1' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a
correlation name which must be used instead.
Command has been aborted.
(0 rows affected)
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
Keywords
823111, CR#823111, CR823111 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
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.