Re: Help formulating multi-table SELECT statement

From: Phil Mitchell <phil(dot)mitchell(at)pobox(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Help formulating multi-table SELECT statement
Date: 2002-02-26 20:39:28
Message-ID: 4.3.2.7.2.20020226153712.00b2d010@pop.rcn.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

At 02:53 PM 2/26/02, you wrote:
>Hey Phil,
>
>Not sure if this will work..don't have any tables like that to test this
>on but try this:
>
>SELECT sig FROM sigs WHERE sigID=(SELECT sigID FROM keys_sigs WHERE
>keyID=(SELECT keyID FROM keys WHERE key = X));

Travis, I had tried nesting the selects like that, but postgres apparently
complains when subselects return multiple values.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Travis Hoyt 2002-02-26 20:58:19 Re: Help formulating multi-table SELECT statement
Previous Message Art Nicewick 2002-02-26 20:05:07 Re: connectDBStart() -- connect failed