Two thumbs up on Igor. They say the quickest way to the correct answer is to post the wrong answer on the internet. Hypothesis just proven.
On Thu, Dec 13, 2018 at 3:00 PM Igor Tandetnik <i...@tandetnik.org> wrote: > On 12/13/2018 3:41 PM, Igor Tandetnik wrote: > > On 12/13/2018 3:27 PM, Don V Nielsen wrote: > >> Making a mountain out of a mole hill, but isn't the solution more > complex > >> that that? The description has to be Foo & Bar. But if given the > following, > >> then the simple answer dies. > > > > select Request from MyTable group by Request > > having sum(Description='Foo') > 0 and sum(Description='Bar') > 0; > > ... and sum(Description not in ['Foo', 'Bar']) = 0 > > Add conditions to taste. > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
