Cross tables Like%

From: jasondavis19(at)hotmail(dot)com (Jason Davis)
To: pgsql-sql(at)postgresql(dot)org
Subject: Cross tables Like%
Date: 2002-09-09 07:20:03
Message-ID: 9e03a267.0209082320.4b2555ca@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Troy 2002-09-09 07:47:49 Re: Character translation?
Previous Message dima 2002-09-09 06:34:48 Re: the best way to get the topest 3 record in every group