[ic] Modifying an existing search to include fields from another table?

[Ron Phipps]

I have the following search profile which currently works.

__NAME__ keyword_search
mv_search_page=search_results
mv_searchtype=db
mv_coordinate=yes
mv_search_file=products
mv_return_fields=sku,title,image,short_description,long_description,msrp
_price,free_batteries,free_shipping,mfgr_id,import_type,option_type,sub_
option_type,hcpcs_code,features
mv_sort_field=title
mv_search_field=:long_description:short_description:title:sku
mv_column_op=aq
mv_search_field=user_inactive
mv_searchspec=0
mv_column_op===
mv_search_field=import_inactive
mv_searchspec=0
mv_column_op===
mv_search_field=price_inactive
mv_searchspec=0
mv_column_op===
mv_matchlimit=10
__END__

I would like to modify this profile so that it will not only look in the
products table, but it will also check the name column in the mfgr table
as well for the search term.  In the products and the mfgr table there
is an mfgr_id column which joins the two tables.

I've read this text on coordinated/joined searches:
http://www.icdevgroup.org/interchange-doc-5.2.0/frames/icdatabase_31.htm
l, but I don't see how to specify the primary/foreign key fields to
complete the join.  In the examples they use the inventory table which
has a sku column as does the products table.  Is it possible to join on
other fields besides the primary key 'sku' of the products table?

Thanks!
-Ron