 |
 |
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 >