Inner Join Part 2

Getting back way too many records with this on - over 4500 and should only be about 350.....

Here's the sql that's not working right: 

SELECT c.Name, a.ID, a.Description, s.Status, b.Location, a.scheduleBegin, a.scheduleEnd

from tblEquipments a

inner join tblEquipments_Group U on u.categoryID = a.EquipmentType

inner join tblStatus S on a.status = S.statusID

and u.subCategoryID = @type

inner join tblLocation b on a.status = b.locationID

inner join tblSubCategories c on u.subCategoryID = @type

and c.Parent = @type

The table tblSubCategories has a field Name that I need. 

tblSubCategories  has a field, Parent, that will = @type

See this post for the other table fields if needed.

 http://forums.asp.net/thread/1489880.aspx

If I omit the last inner join, all is ok, but I need that last bit of info - the c.Name. 

Suggestions?

Thanks,

Zath