Re: Why relational division is so uncommon?
Date: 26 Apr 2007 11:55:45 -0700
Message-ID: <1177613745.189501.141120_at_r35g2000prh.googlegroups.com>
On Apr 25, 11:16 am, Vadim Tropashko <vadimtro_inva..._at_yahoo.com>
wrote:
> http://vadimtropashko.wordpress.com/why-relational-division-is-so-unc...
In my experience, those "find (exactly) matching sets" type questions are particularly tricky. On the subject of Rel Div, I thought Itzik Ben-Gan's June and July '03 articles in SQL Server Magazine were exemplary:
July 2003
A Different Setup
When your query needs to find items with certain relationships, you
can use relational division, or you can try these new tricks.
June 2003
Set Members and Relationships
You can use Set Theory to identify groups of items that have a certain
relationship to other items.
Looking forward to the receipt of your book ("it's in the mail").
--Jeff Received on Thu Apr 26 2007 - 20:55:45 CEST