From: Viacheslav N Tararin <taras@dekasoft.com.ua>
To: Jason Davis <jasondavis19@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Cross tables Like%
Date: Mon, 09 Sep 2002 17:05:06 +0300
Message-ID: <3D7CAA92.4050605@dekasoft.com.ua> (raw)
References: <9e03a267.0209082320.4b2555ca@posting.google.com>
select products.*, manufactors.*
from products, manufactors
where products.manufactor_id=manufactors.manufactor_id
and ( products.product_description like 'param%' or
manufactors.manufactor_description like 'param%');
regards
Jason Davis ?????:
>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!
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html
>
>
>
>
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: taras@dekasoft.com.ua, jasondavis19@hotmail.com
Subject: Re: Cross tables Like%
In-Reply-To: <3D7CAA92.4050605@dekasoft.com.ua>
* 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