[ic] Join search in 4.8.3 & mv_search_groups

[Steve Graham]

I found that this SQL Query does what I need, but how do I write this doing 
a loop search.

query sql="select * from products,pricing where products.sku = pricing.sku 
AND pricing.price_group='test' ORDER BY products.description"
         type=list
         more=1
           ml=10]

Thanks


>From: "Steve Graham" <dtlgc@hotmail.com>
>Reply-To: interchange-users@interchange.redhat.com
>To: interchange-users@interchange.redhat.com
>Subject: [ic] Join search in 4.8.3 & mv_search_groups
>Date: Sat, 08 Dec 2001 03:42:18
>
>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


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