]]
Sent: Thursday, 23 January 2003 5:24 AM
To: [EMAIL PROTECTED]
Subject: solution for opposite of this join / join from this subselect
thanks to brent, bob and M wells for their contributions to this
solution
and to m especially who seems to have put in a lot of time and nailed
it.
This query
See interleaved comments below.
Subject: solution for opposite of this join / join from this subselect
To: [EMAIL PROTECTED]
From: Josh L Bernardini [EMAIL PROTECTED]
Date: Wed, 22 Jan 2003 11:23:44 -0800
thanks to brent, bob and M wells for their contributions to this solution
and to m
thanks to brent, bob and M wells for their contributions to this solution
and to m especially who seems to have put in a lot of time and nailed it.
This query returns a list of people not attending a particular event, given
an events table, a people table, and a many-many epeople table between
Then, you can apply an additional WHERE clause to that.
hth
Subject: join from this subselect
To: [EMAIL PROTECTED]
From: Josh L Bernardini [EMAIL PROTECTED]
Date: Tue, 21 Jan 2003 11:51:13 -0800
I can't come up with the join syntax to mimic this subselect query to list
people not attending
I can't come up with the join syntax to mimic this subselect query to list
people not attending an event (*epeople.eid == event.id):
select people.id as pid, concat(lastname, , , firstname) as name from
people where people.id not in
(select epeople.pid from
epeople
left join people on
On Tue, 2003-01-21 at 15:51, Josh L Bernardini wrote:
I can't come up with the join syntax to mimic this subselect query to list
people not attending an event (*epeople.eid == event.id):
select people.id as pid, concat(lastname, , , firstname) as name from
people where people.id not in