On Tue, Jan 21, 2003 at 01:38:42PM -0800, Josh L Bernardini wrote: > > Bob, > First of all, thank you. I never would have gotten here on my own. Only I > am not quite there. > Using your example, I have managed to list all the events a person is > attending and not attending. Wondering if you might provide some further > clues as to how to restrict the query to those events a person is not > attending, or in you example, those items a person doesn't own. > > This step is towards the goal of returning all the people not attending an > event - or not owning a desk. > > Also what is the significance of the value returned in the attends column? > > Here's what I've got: > > mysql> SELECT events.event, > -> people.lastname, > -> Sum(epeople.eid = people.id) AS attends > -> FROM (events, people) LEFT JOIN epeople > -> ON events.id = epeople.eid > -> WHERE people.id=1 > -> Group by events.id;
It's been a while since I worked with this query, so I'm not sure that this answer is correct. However, after quickly going over the article again, I believe you can treat the attends column as a boolean type. Add "AND attends = FALSE" to the WHERE clause to get the events they will not attend. If that works, it answers both of your questions. (You can also use "attends = 0", but "attends = FALSE" is more self-documenting.) HTH Bob Hall --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
