Re: [SQL] How can I produce the following desired result?

[Rod Taylor]

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>

signature.asc
Description: This is a digitally signed message part