Posted by Comagmbh on 12/19/06 11:35

Hi

Thanks for your answer, but the problem still exists. There is the same
error message like before.

othellomy@yahoo.com schrieb:

>
> ALTER VIEW view_results_7
> AS
> SELECT TOP 100 PERCENT view_results_7a.*, table.MCC,
> table.MNC, ...table.HPRP
> FROM view_results_7a INNER JOIN
> table ON view_results_7a.MCC = table.MCC
> WHERE view_results_7a.IMSI <> tblIMSI_Stiering_Blacklist.IMSI
> ORDER BY view_results_7a.BegTime DESC
>


I have forgot to tell you that the table tblIMSI_Stiering_Blacklist is
from another database but on the same server, so I have to write in
this way:

ALTER VIEW view_results_7
AS
SELECT TOP 100 PERCENT view_results_7a.*, table.MCC,
table.MNC, ...table.HPRP
FROM view_results_7a INNER JOIN
table ON view_results_7a.MCC = table.MCC
WHERE view_results_7a.IMSI <>
IMSI_Blacklist.dbo.tblIMSI_Stiering_Blacklist.IMSI
ORDER BY view_results_7a.BegTime DESC

The error is still the same :-(

• Next in forum: Re: Replacing NULL value in multiple columns in a table
• Prev in forum: Conditional query results
• Thread view: Re: A question about an error message

[Reply to this message]