I'm working on learning mySQL, and SQL in general. I have a database book from college (just last year, so it's not an old one) and was looking for a way to do a difference between two groups. In my book, it says to use the EXCEPT operation, but either I did it wrong or it doesn't exist. Here's roughly what I typed:
(select Computer.CompID, Computer.Location, Computer.User from Computer where Computer.OS like "Microsoft*") except all (select Software.CompID from Software where Software.Name = "Excel"); Basically I want to know what computers in my list don't have the program Excel. Did I do this right, or did I miss something? I did check the manual, but I didn't find anything that looked correct. Brian Ronk --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
