Cross tables Like% - Mailing list pgsql-sql

From jasondavis19@hotmail.com (Jason Davis)
Subject Cross tables Like%
Date
Msg-id 9e03a267.0209082320.4b2555ca@posting.google.com
Whole thread Raw
List pgsql-sql
I have 2 tables, one is products and one is manufactors.

The products table has a col. for Product_descriptions and manufactor_id
column that is a foriegn key to the manufactors table.

The manufactors table has a manfuactor_description column, for each unique
Manufactor_id.

I want to search (using like) on both tables (columns:
Products.Product_description and Manufactors.Manufactor_description).

Can anyone suggest a cross-table %Like% Query for it?

Thanks!


pgsql-sql by date:

Previous
From: "Jay"
Date:
Subject: Database joins
Next
From: Bruno Wolff III
Date:
Subject: Re: Efficiency Question