[ic] Join search in 4.8.3 & mv_search_groups

Michelle Wilant interchange-users@interchange.redhat.com
Sat Dec 8 00:34:00 2001


My $.02

Just use sql --- send a form to one of the .html pages -- then put your 
query on the html page and fill in the blanks with what you submitted in 
the form.

Steve Graham wrote:

> 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
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users
>
> .
>