pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Cross tables Like%
2+ messages / 2 participants
[nested] [flat]

* Cross tables Like%
@ 2002-09-09 07:20  Jason Davis <jasondavis19@hotmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: jasondavis19@hotmail.com @ 2002-09-09 07:20 UTC (permalink / raw)
  To: 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!



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Cross tables Like%
@ 2002-09-09 14:05  Viacheslav N Tararin <taras@dekasoft.com.ua>
  parent: Jason Davis <jasondavis19@hotmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Viacheslav N Tararin @ 2002-09-09 14:05 UTC (permalink / raw)
  To: Jason Davis <jasondavis19@hotmail.com>; pgsql-sql

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
>
>
>  
>






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2002-09-09 14:05 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-09-09 07:20 Cross tables Like% Jason Davis <jasondavis19@hotmail.com>
2002-09-09 14:05 ` Viacheslav N Tararin <taras@dekasoft.com.ua>

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