Posted by Erland Sommarskog on 12/19/06 16:28

(Comagmbh@gmx.de) writes:
> Hi! Okay I wrote this:
>
> ALTER VIEW view_results_7
> AS
> SELECT view_results_7a.*, table.MCC,
> table.MNC, ...table.HPRP
> FROM view_results_7a INNER JOIN
> table ON view_results_7a.MCC = table.MCC AND view_results_7a.MNC =
> table.MNC
> WHERE view_results_7a.IMSI <>
> IMSI_Blacklist..tblIMSI_Stiering_Blacklist.IMSI
>
>
> But there is still this error message:
>
> Server: No 107, 16, state 3 procedure view_results_7
> "The column prefix '%.*ls' does not match with a table name or alias
> name used in the query."

What ugly environment are you using that only gives the unexpanaded
error message?

In any case, that IMSI_Blacklist..tblIMSI_Stiering_Blacklist still
comes out of nowhere. You need to mention it in the FROM-JOIN clause.

Besides, you have something called "table" in the query above. Since
TABLE is a reserved keyword, I would expect that to yield a syntax error,
so I suspect that you are not even posting the query you are using.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]