querryStr="Select * from [product] as prd " +
"inner join [attribute] as attr on
ISCHILDNODE(attr,prd)" +
" inner join [attribute] as attr1 on
ISCHILDNODE(attr1,prd) " +
"inner join [attribute] as attr2 on
ISCHILDNODE(attr2,prd)" +
" where" +
" prd.catalogPrdName='motor' and
attr.AttributeName='height' and
attr.AttributeValue>=23" +
"and attr1.AttributeName='color' and
attr1.AttributeValue='white'" +
"and attr2.AttributeName='weight' and
attr2.AttributeValue>=217.0"
run this querry thats give result
--
View this message in context:
http://jackrabbit.510166.n4.nabble.com/SQL2-via-davex-tp3730048p4658821.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
