James Black <[EMAIL PROTECTED]> wrote on 11/22/2005 03:48:28 PM: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > I am wondering if there is a set-based minus operator. > > I am assuming there isn't, but I thought I would ask. > > Here is the query I am trying that fails. > > Thank you. > > select n.name > from names n, transactions t > where n.name=t.name > MINUS > select nb.name > from stats_names sn > > - -- > "Love is mutual self-giving that ends in self-recovery." Fulton Sheen > James Black [EMAIL PROTECTED] > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.1 (MingW32) > Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org > > iD8DBQFDg4QcikQgpVn8xrARAsFUAJ4h/vh+lcIsSASydKLzR1U4Qs62aQCeOCxk > rjzBfzwg5hoHAAOIrnL1qD4= > =9YjG > -----END PGP SIGNATURE-----
You can easily answer this yourself if you would only RTFM. http://dev.mysql.com/doc/refman/5.0/en/index.html Try the search feature, it works very well. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
