Viewing 3 posts - 31 through 33 (of 33 total)
Just wanted to add, this is a perfect use case for the EXISTS clause with a correlated sub query.
September 3, 2013 at 11:29 am
#1647112
I've always had a theory that there are two kinds of coders: mechanics and poets. I'm more of a poet myself - if the code looks wrong or ugly or...
August 16, 2013 at 8:12 am
#1642194
I've dealt with this kind of thing a few different ways.
The first thing to remember is that hierarchical data represents a relationship. In your case, there is a one-to-many relationship...
August 7, 2013 at 8:12 am
#1639406