Re: Search for data in a similar field in a related table, too

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: szucs <janos(dot)szucs(at)meei(dot)hu>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Search for data in a similar field in a related table, too
Date: 2003-09-10 13:05:51
Message-ID: 20030910130551.GA25627@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wed, Sep 10, 2003 at 11:26:27 +0200,
szucs <janos(dot)szucs(at)meei(dot)hu> wrote:
> I have 2 tables:
>
> MainTable, fields: id, data1
> RelatedTable, fields: id, data2
>
> RelatedTable is joined to MainTable via the 'id' field.
> Field 'data2' in RelatedTable holds the same sort of data as 'data1' in
> MainTable, though they may be different in length.
>
> I could not figure out an SQL query, which returns all records where either
> 'data1' in the MainTable or 'data2' in the joined RelatedTable complies with
> a common search condition.
> (For the case of simplicity I did not mention that MainTable has more
> fields, for which separate seach conditions may apply)
>
> Is it possible to construct such an SQL query?

Yes. Join the two tables and repeat the search condition for data1 and
data2 using 'or' as a connector (and probably with surrounding parens).

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jason Hihn 2003-09-10 13:12:58 Re: Lyris and Postgres
Previous Message Mickey 2003-09-10 13:00:50 Lyris and Postgres