Re: combining

From: Jie Liang <jliang(at)ipinc(dot)com>
To: Frank Morton <fmorton(at)base2inc(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: combining
Date: 2001-02-12 18:46:11
Message-ID: Pine.BSF.4.10.10102121038390.23715-100000@tidal.ipinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Jie LIANG

St. Bernard Software
Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang(at)ipinc(dot)com
www.stbernard.com
www.ipinc.com

On Mon, 12 Feb 2001, Frank Morton wrote:

> I'll really appreciate help on this if anyone will do so. I'm
> used to single-table stuff, but not sure the best way to
> do things with multiple tables, but here goes:
>
> Given two tables with a common "id" field, first table columns:
>
> id
> lastname
>
> Second table columns:
>
> id
> type
> content
>
> These two queries get me what I want from each table:
>
> select unique id from table1 where lastname='morton';
> select unique id from table2 where ((type = "pie") and (content =
'apple));

it depends what you want:
1.
select id from table1 where lastname='morton' and id=table2.id
and table2.type = 'pie' and table2.content ='apple';
will return you the id in the intersection of 2 sets.
2.
select id from table1 where lastname='morton' union
select id from table2 where ((type = 'pie') and (content =
'apple'));
will return you a set1+set2;

>
> What is the best way to combine these into one query?
>
> Thanks.
>
> Frank
>
>

In response to

  • combining at 2001-02-12 18:20:19 from Frank Morton

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 2001-02-12 19:01:32 Re: combining
Previous Message Frank Morton 2001-02-12 18:20:19 combining