On Wed, Nov 6, 2013 at 12:55 PM, Ulrich Goebel <m...@fam-goebel.de> wrote:
> Is it a matter of a "simple" SELECTs with joined tables? Have I to think > about subqueries? Or even Compund SELECTs (UNION, INTERSECT)? > > It would be great to get some hints! Sounds like a job for http://en.wikipedia.org/wiki/Join_(SQL)#Left_outer_join with the group table on the left, and the relation table on the right, with a where clause on the member column of the relation table, with a function call (nvl/ifnull/etc... or a CASE) to transform the NULL or not into "yes" or "no". Obviously untested, but that's how I'd try it. --DD _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
