That does it! Thanks much.
Jim
On Saturday, March 29, 2003, at 06:14 PM, Bruce Feist wrote:
Jim Miller wrote:
I want to do a join and select of these tables that will give me all
the Entrants who did NOT enter contest 1 (i.e., Mary and Bill).
Try:
select entrant.name
from entrant
This is probably a real newbie question, but, since that's what I am...
Using MySQL 3.23, I have two tables, for instance:
ContestEntries: id, entrant, contestNumber, etc.
Entrant: id, name, etc.
There are multiple contests, and Entrants can enter as many as they
like. So, Entra