Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multi-part identifier can not be bound
Message
 
 
À
10/08/2007 15:21:12
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01247498
Message ID:
01247500
Vues:
27
What double quotes are doing in the statement?

>
>First, let me get this off my chest. "I Hate SQL Server Help! I Hate SQL Server Help! I Hate SQL Server Help!"
>
>okay, now I have a select statement:
>
>SELECT DISTINCT RunRoute.RunRte_Rte_ID "
>FROM RunRoute "
>WHERE '20' = RunRoute.RunRte_Run_AutoID AND
>RunRoute.RunRte_Rte_ID != 'NULL' AND RunRoute.RunRte_Rte_ID != ''
>
>
>I run it and get these errors:
>Msg 4104, Level 16, State 1, Line 1
>The multi-part identifier "RunRoute.RunRte_Run_AutoID" could not be bound.
>Msg 4104, Level 16, State 1, Line 1
>The multi-part identifier "RunRoute.RunRte_Rte_ID" could not be bound.
>Msg 4104, Level 16, State 1, Line 1
>The multi-part identifier "RunRoute.RunRte_Rte_ID" could not be bound.
>Msg 4104, Level 16, State 1, Line 1
>The multi-part identifier "RunRoute.RunRte_Rte_ID" could not be bound.
>
>I did several LARGE Select statements into temporary tables before this in the same query window, and they worked fine. This is to permanent tables and it errors on me. Help is not helping me on this.
>
>What do these errors mean, how can I check things for it?
>
>TIA
>Beth
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform