hi bartlomiej,

i mean did you enter the select in a gui-application that calls ms-sqlserver ? i would like to know which column alias caused the problem because the query looks ok to me. (except 'zp_czznd', is this an indirection table ?)

jakob


Bartłomiej Knabel schrieb:
Hi Jakob,

JB> please try to execute the sql in mssqlserver directly, we'll probably
JB> get a more detailed error message.

this is direct from sql server :


Server: Msg 107, Level 16, State 2, Line 1
The column prefix 'A0' does not match with a table name or alias name used in 
the query.




--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to