Steve Bryant wrote: > I expected that to work as well (in fact, I thought that I had used this > approach successfully in the past). I tried it again this time, however, > and it didn't work. > > Some rows from "lessons" were missing.
I have the same problem where I'm using a similar query to get back a list of keywords assigned to a user. No luck in finding out why this isn't working though. > Would it matter that while "lessons" has a primary key of "LessonID", > "students" has a joint primary key of "LessonID" and "UserID"? No, it doesn't. For me, the list of keywords assigned to the user isn't indexed at all or part of another key. I don't do lookups on it except in joins where I'm doing a lookup on a key that's part of the same table. > Or perhaps this is an oddity of SQL Server 2000? Could be. Believe me, I'd like to know why this doesn't work as you'd think it should myself. I'm pretty sure I've used the same technique on other RDBMSs before and it's given me no problems. K. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198789 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
