[ic] Searching tables

Kevin Flynn interchange-users@lists.akopia.com
Wed Jun 6 11:43:01 2001


I am trying to translate the sql statement below into a search region where
it pulls from 2 tables.

        SELECT * FROM transactions, orderline WHERE description =
"given_keyword" AND
        transaction.order_number = orderline.order_number;

I want to search through the orders to see who bought a particular product
(i.e. Hand Planer) and pull back all relevant information for that order
(i.e. Order number, username, address, etc...). The product Description is
in the orderline table whereas all customer details are in the transactions
table.

I'd appreciate some help with this as I have been banging my head against a
wall for ages trying to figure it out!



----- Original Message -----
From: Ed LaFrance <edl@newmediaems.com>
To: <interchange-users@developer.akopia.com>
Sent: 05 June 2001 17:11
Subject: Re: [ic] Search across multiple tables


> At 02:49 PM 06/05/2001 +0100, you wrote:
> >is it possible to perform a search across multiple tables in a database.
> >
> >i.e. Search through orders based on customer details or items bought.
> >Customer details are in transactions table and products purchased in
> >orderline table.
>
> mv_search_field (sf) does take a table:field syntax, so it is possible to
> qualify search results with data in multiple tables. It tends to work best
> with coordinated searches.
>
> - Ed L.
>
>
>
>
>
>
>
>
> >_______________________________________________
> >Interchange-users mailing list
> >Interchange-users@lists.akopia.com
> >http://lists.akopia.com/mailman/listinfo/interchange-users
>
> ===============================================================
> New Media E.M.S.               Software Solutions for Business
> 463 Main St., Suite D          eCommerce | Consulting | Hosting
> Placerville, CA  95667         edl@newmediaems.com
> (530) 622-9421                 http://www.newmediaems.com
> (866) 519-4680 Toll-Free       (530) 622-9426 Fax
> ===============================================================
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users
>