Posted by othellomy on 12/20/06 04:27

Hi,
As suggested by Erland, table is a reserve keyword therefore you
can't have it in your query. I thought you are using table to
reference some pseodo table in the from clause so I used that because
you did not post the actual query. You have to post the actual query
for two reasons. Reason 1: I can see if you are using the 'table'
keyword in your query. If yeas, then it is obvious that was the error.
Number 2: if you have a table name in the select clause but missing
from the from clause then it will also cause error and also if you have
more tables in the from clause but not joining them appropriately in
the join or where clasue then it will be error too. So, the best thing
is if you post the actual query exactly as is.

Comagmbh@gmx.de wrote:
> 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 :-(

[Back to original message]