In Sum(), join people IDs to people IDs, not to event IDs. In the article, the SQL statement is mostly ok, but the explanation section proves, once again, that I shouldn't be proofreading my own stuff. I've cleaned it up, so there won't be any more errors until I look at it the next time.
On Tue, Jan 21, 2003 at 07:34:47PM -0800, Josh L Bernardini wrote: > > Thats what was strange with the results. One of the meetings the user was > attending had a value of 9, the other 0. > Might just give up doing this and use 2 queries to accomplish the same so > don't spend anymore time on it unless your curious yourself. > thanks just the same, > jb > > > |---------+----------------------------> > | | "Bob Hall" | > | | <rjhalljr@starpow| > | | er.net> | > | | | > | | 01/21/2003 06:57 | > | | PM | > | | | > |---------+----------------------------> > >>--------------------------------------------------------------------------------------------------------------------------------------------------| > | > | > | To: [EMAIL PROTECTED] > | > | cc: > | > | Subject: Re: opposite of this join > | > >>--------------------------------------------------------------------------------------------------------------------------------------------------| > > > > > 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.) --------------------------------------------------------------------- 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