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>