Re: How can I produce the following desired result?

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: aicean <aicean(at)netspeed-tech(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How can I produce the following desired result?
Date: 2003-10-15 02:27:47
Message-ID: 1066184866.99719.9.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 wanted goodid>
) AS tab
USING (goodid)
WHERE <other clauses>

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message aicean 2003-10-15 03:02:12 Re: How can I produce the following desired result?
Previous Message aicean 2003-10-15 02:09:11 How can I produce the following desired result?