On Wed, Feb 3, 2010 at 3:23 PM, KARR, DAVID (ATTCINW) <[email protected]>wrote:
> > I'm not sure if you are expecting to get a subset of foo.childBars. If > > you > > are, this won't work. > > I don't understand the last statement here. > > If the foo you are interested in has 5 bar children, but only 3 match the date range, you might expect to get the foo plus the 3 matching children. When I first started out, that's what I thought I'd get, but you'll get all 5 with the fetch join. (The join without distinct will get you 3 rows of the same foo, but each foo will have all 5 in childBars.) You need to reverse things as Craig suggested to get that. Sorry if I suggested you are as "naive" as I was when I started! :-) -- Daryl Stultz _____________________________________ 6 Degrees Software and Consulting, Inc. http://www.6degrees.com mailto:[email protected]
