I'm fully aware that set division can be accomplished through a series of other operations, so my question is:
Is there a command for set division in SQL?
I'm fully aware that set division can be accomplished through a series of other operations, so my question is:
Is there a command for set division in SQL?
http://vadimtropashko.files.wordpress.com/2007/02/ch3.pdf
From Page 32:
Relational Division is not a fundamental operator. It can be expressed in terms of projection, Cartesian product, and set difference.
So, no. :)
Related question: http://stackoverflow.com/questions/48475/database-design-for-tagging
And relevant part of answer is this article
So in short, no, there is no set division in SQL.