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
