Last I checked MySQL doesn't support MINUS, but it's been a few years
since I used it.  I vaguly remember talk about the developers planning on
adding it.  I took a quick glance at the docs, but I can't seem to find
anything one way or another.  Is it in one of the later versions of MySQL?


On Fri, 26 Jan 2007, Jeffrey Barnett wrote:

> You have gotten a lot of suggestions, but here is one more.
>
> select * from lib_books where good_thing = 'TRUE'
> MINUS
> select * from lib_books where bad_thing = 'TRUE'
>
> I think MINUS is faster than JOIN.
>
> Other SET OPERATIONS include UNION and INTERSECT.
>
> Set operations require that the underlying result sets be "compatible":
> Same number of columns.
> Corresponding columns have matching datatypes.
>
>
> Ken Irwin wrote:
>> Hi all,
>>
>> Thanks for these myriad responses! I've gotten at least three distinct
>> approaches to try. I knew there had to be a better way.
>>
>> your sql-fu is appreciated!
>>
>> joys
>> Ken
>