[ic] query error in products search

[Salvador Caballe]

El 30/04/15 a les 08:42, Stefan Hornburg (Racke) ha escrit:
> On 04/28/2015 10:50 PM, Salvador Caballe wrote:
>> Hi all.
>>
>> I use the following code in the promo component
>> to show only items in stock
>>
>> [query arrayref=main
>>
>> SELECT m.sku, m.timed_promotion, m.start_date, m.finish_date
>> FROM [either]__UI_MERCH_TABLE__[or]merchandising[/either] m, inventory i
>> WHERE m.featured = '[control promo_type specials]'
>> AND i.sku = m.sku
>> AND i.quantity >= 1
>>
>>   "][/query]
>>
>>
>> runs OK, but now I try to use locale options in the products database, and I have the following error:
>>
>> Died in server spawn: Bad column name (from m.sku): 'm.sku' at /home/interch/interchange/lib/Vend/SQL_Parser.pm line 838.
>
> Unfortunately the support for MAP and queries using multiple tables is limited / missing.
>
> Regards
> 	Racke
>
>>


Is possible to do the same multimple table  query with interchange 
search instead SQL ??

Salvador