The multi-part identifier "STATUS.STATUS_ID" could

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

The multi-part identifier "STATUS.STATUS_ID" could

Author

Topic

yasinirshad
Starting Member

18 Posts

Posted - 2007-08-08 : 03:30:28

HI
am getting this error:
The multi-part identifier "STATUS.STATUS_ID" could not be bound.
Query is:

strSQL = "SELECT STATUS.STATUS_ID,STATUS.STATUS_LABEL FROM STATUS INNER JOIN CALLS on STATUS.STATUS_ID=CALLS.STATUS_ID AND CALLS.CALL_ID= '" & Session("CALL_ID") & "'Union All Select STATUS.STATUS_ID, 'CLOSE' As STATUS_LABEL"

How do i fix this.. plss help
thanks..

Koji Matsumura
Posting Yak Master

141 Posts

Posted - 2007-08-08 : 03:41:25

.......Union All Select STATUS.STATUS_ID, 'CLOSE' As STATUS_LABEL
Above statement has no FROM.
Where do you expect STAUTS.STATUS_ID to come from?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources