Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1028C476299 for ; Mon, 9 Sep 2002 10:11:24 -0400 (EDT) Received: from dekasoft.com.ua (unknown [193.201.199.5]) by postgresql.org (Postfix) with ESMTP id A1373476540 for ; Mon, 9 Sep 2002 10:07:46 -0400 (EDT) Received: from dekasoft.com.ua (unknown [192.168.1.9]) by dekasoft.com.ua (Postfix) with ESMTP id AA638CF69; Mon, 9 Sep 2002 17:07:46 +0300 (EEST) Message-ID: <3D7CAA92.4050605@dekasoft.com.ua> Date: Mon, 09 Sep 2002 17:05:06 +0300 From: Viacheslav N Tararin User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; ru-RU; rv:1.0.0) Gecko/20020526 X-Accept-Language: uk, ru, en-us MIME-Version: 1.0 To: Jason Davis , pgsql-sql@postgresql.org Subject: Re: Cross tables Like% References: <9e03a267.0209082320.4b2555ca@posting.google.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/47 X-Sequence-Number: 9324 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 > > > >