Re: embedded select / left join question

[Bruce Feist]

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]