Re: embedded select / left join question

[Jim Miller]

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 left join contestEntries
      on entrant.id = contestEntries.entrant AND
contestEntries.ContestNumber = 1
      where contestEntries.entrant is null
Bruce Feist



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]