🚀 go-pugleaf

you should be able to do what you want, by combining two selection
formulas with IN. the query bolow should do the trick

select id
from table
where keyname = 'c'
and id IN (
select id
from table
where keyname = 'a'
or keyname = 'b')



Shawn Hughes wrote:
> 
> 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.