[ic] Join search in 4.8.3 & mv_search_groups

Steve Graham interchange-users@interchange.redhat.com
Fri Dec 7 22:43:00 2001


Hello,

I'm trying to do something like a Join or merge search like in SQL
(psuedo code)
select * from products,pricing join on sku where pricing.price_group=test 
and products.category=big

It seems that I should be able to use something like, but I don't have a 
good grasp of the sequence of setting variables.


[loop search="
co=yes
fi=pricing
sf=price_group
se=test
sg=0

fi=products
sf=category
se=big
sg=1
sr=0 AND 1
tf=description
"]


Thanks,
Steve

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp