Re: How can I produce the following desired result? - Mailing list pgsql-sql

From Rod Taylor
Subject Re: How can I produce the following desired result?
Date
Msg-id 1066184866.99719.9.camel@jester
Whole thread Raw
In response to How can I produce the following desired result?  ("aicean" <aicean@netspeed-tech.com>)
List pgsql-sql
On Tue, 2003-10-14 at 22:09, aicean wrote:
> How can I produce the following desired result?

I'm not sure I understand the problem, but you might want to try a
subselect in the FROM.

SELECT <wanted results> FROM table JOIN (SELECT goodid         FROM table        WHERE <whatever you did to get list of
wantedgoodid>      ) AS tab      USING (goodid)WHERE <other clauses> 

pgsql-sql by date:

Previous
From: "aicean"
Date:
Subject: How can I produce the following desired result?
Next
From: "aicean"
Date:
Subject: Re: How can I produce the following desired result?