I'm trying to select all members who have not registered for an event. I
have tables 'members', 'events', and 'events_members', the latter a join
table with event_id and member_id columns.
The closest I've gotten is with this query:
SELECT m.id, m.first_name, m.last_name
FROM members AS m
On Sat, 19 Sep 2009, b wrote:
I'm trying to select all members who have not registered for an event. I
have tables 'members', 'events', and 'events_members', the latter a join
table with event_id and member_id columns.
The closest I've gotten is with this query:
SELECT m.id, m.first_name,
On 09/19/2009 10:07 AM, Thomas Spahni wrote:
On Sat, 19 Sep 2009, b wrote:
I'm trying to select all members who have not registered for an event.
I have tables 'members', 'events', and 'events_members', the latter a
join table with event_id and member_id columns.
The closest I've gotten is