I would think that: SELECT email FROM participants WHERE email NOT IN (SELECT email FROM excluded)
would do the trick.... andy > I am trying to do something like this > > select email from participants > minus > select email from excluded > > It seems there is no minus function in MySQL. I tried goofing around with > intersects and union, but can't seem to make it work. > > > > Is there a better way to achieve the same thing? > > > > Thanks in advance for your help! > > > > -Brian Menke > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]