List:General Discussion« Previous MessageNext Message »
From:Andrew Wallace Date:April 23 2007 4:06pm
Subject:Re: What is the equivalent of the minus function?
View as plain text  
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
>
>


Thread
What is the equivalent of the minus function?Brian Menke21 Apr
  • Re: What is the equivalent of the minus function?Peter Brawley21 Apr
  • Re: What is the equivalent of the minus function?Andrew Wallace23 Apr