Re: How can I produce the following desired result?

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>