🚀 go-pugleaf

How do you group attributes from one table
and 'OR' the elements from one group and
'AND' the sets of results.  For example...

table tab1(index keyname)
keyname     group
a                          1
b                          1
c                          2

table tab2 (index id, keyname)
id                    keyname
1001                    a
1002                    a
1002                    c
1003                    b
1003                    c
1004                    c

My query is "Give me the articles which have (either attribute
'a' or attribute 'b') AND attribute 'c'.

Based on this set, I need to select id=1002 (because it has both
'a' and 'c' attributes) and id=1003 ('b' and 'c').

Any pointers would be appreciated.

Shawn.