Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 76D8A47629B
	for <pgsql-sql@postgresql.org>; Mon,  9 Sep 2002 04:48:48 -0400 (EDT)
Received: from news.hub.org (news.hub.org [64.49.215.80])
	by postgresql.org (Postfix) with ESMTP id 086CB476299
	for <pgsql-sql@postgresql.org>; Mon,  9 Sep 2002 04:48:48 -0400 (EDT)
Received: by news.hub.org (Postfix, from userid 8)
	id 6E725381995; Mon,  9 Sep 2002 04:48:47 -0400 (EDT)
From: jasondavis19@hotmail.com (Jason Davis)
X-Newsgroups: comp.databases.postgresql.sql
Subject: Cross tables Like%
Date: 9 Sep 2002 00:20:03 -0700
Organization: http://groups.google.com/
Lines: 14
Message-ID: <9e03a267.0209082320.4b2555ca@posting.google.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Complaints-To: groups-abuse@google.com
To: pgsql-sql@postgresql.org
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200209/44
X-Sequence-Number: 9321

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!