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 |
|
Zath
Constraint Violating Yak Guru
298 Posts |
 Posted - 2007-10-02 : 11:38:46
|
| If I leave out the EquipmentHeader eh and comment the two inner joins referring to it, it runs ok.But as is, I get the error:The multi-part identifier "ca.StatusID" could not And here's the select: SELECT COUNT(*) AS CaseCount FROM [dbo].[Case] ca, EquipmentHeader eh INNER JOIN CaseStatus ON ca.StatusID = CaseStatus.CaseStatusID INNER JOIN LocationLink ON ca.LocationID = LocationLink.LocationID AND LocationLink.LocationGroupID = @locationGroupID INNER JOIN Location l ON eh.LocationID = l.LocationID INNER JOIN LocationLink ll ON l.LocationID = ll.LocationID So, how to fix this?Thanks,Zath |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-10-02 : 11:43:24
|
| you forgot to put the join betweenFROM [dbo].[Case] ca, EquipmentHeader eh_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
|
|
|
The multi-part identifier "ca.StatusID" could not