Hi people,
I have four entities and they have ralationship.Example:
product|-1->--*-|property|-1->-*-|productRuleProperty|-<*---1| textRuleProperty|
----------
and I have query
"from Product as p join p.properties pp join pp.productRuleProperties prp join prp.textRuleProperty trp where trp.name='Mono' and trp.name='Numeric'"
And when I execute query I get 0 result.I'm sure that one product has both values in text rule,but when I remove one of these values ,result is ok.How do I resolve this problem?Does anybody know different solution?
tnx,
mb
