Hi All,
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