From: jasondavis19@hotmail.com
To: pgsql-sql@postgresql.org
Subject: Cross tables Like%
Date: 9 Sep 2002 00:20:03 -0700
Message-ID: <9e03a267.0209082320.4b2555ca@posting.google.com> (raw)
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!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jasondavis19@hotmail.com
Subject: Re: Cross tables Like%
In-Reply-To: <9e03a267.0209082320.4b2555ca@posting.google.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox