MySQL Forums
Forum List  »  PHP

A Kind of Reverse Join
Posted by: Allen Moore
Date: June 05, 2012 01:35PM

I've got kind of a reverse join that I want to accomplish:

I have two tables (of course).
One contains a list of all members (called Members): Mem_ID, FName, LName, Age, and Grade
The other one is a linking table (called Mem_Event) that includes the Mem_ID and an Event_ID.
(The third table, not included in this proble, is an event table that lists Event_ID, description, time, date, etc).

When I display the page to edit events (the event ID is passed as part of the $_Get array as event_id), I want to include a list of all members in the database that are NOT registered for the event (i.e. there's not a row in the Mem_Event table that includes the event_id in question and the specific Mem_Id). I think it would be a special type of join but I'm not sure how to create it.

Thanks.

Options: ReplyQuote


Subject
Written By
Posted
A Kind of Reverse Join
June 05, 2012 01:35PM
June 06, 2012 01:33PM
June 06, 2012 01:31PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.