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.
| Author |
Topic |
|
pgmr1998
Yak Posting Veteran
66 Posts |
 Posted - 2010-09-30 : 16:35:32
|
| I am getting the foll error message:Msg 4104, Level 16, State 1, Line 1The multi-part identifier "TM_Category.ID" could not be bound.Here is my code:select * from te_TimeCapture, tm_CategoryTM_project, te_timesheet, TM_User,te_list_timeCaptureTypewhere TM_Category.ID = TE_TimeCapture.CategoryCIDorder by TE_TimeCapture.CategoryCIDDoes anyone know what this means? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pgmr1998
Yak Posting Veteran
66 Posts |
Posted - 2010-09-30 : 17:13:18
|
| I get the same result:select * from te_TimeCapture, TM_project, te_timesheet, TM_User,te_list_timeCaptureTypeinner join TM_Category on TM_Category.ID = TE_TimeCapture.CategoryCIDorder by TE_TimeCapture.CategoryCIDMsg 4104, Level 16, State 1, Line 1The multi-part identifier "TE_TimeCapture.CategoryCID" could not be bound. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-09-30 : 17:15:25
|
| Forget the binding message, unless you've left out a lot of where clause conditions, you have a multi-cartesian product there. 6 tables and only two have any 'join' defined.--Gail ShawSQL Server MVP |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-09-30 : 17:16:14
|
| Does TM_Category have a column called ID in it?--Gail ShawSQL Server MVP |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-09-30 : 17:17:54
|
| Tara, you have a stray comma in that, before the JOIN--Gail ShawSQL Server MVP |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
multi-part identifier error