The sub-select only returns a single row, so IN(...) is only looking at a single value in the list .. it doesn't "expand" to into IN (5,7,11).
On Mon, Dec 20, 2010 at 11:52 AM, muhammad subair <msub...@gmail.com> wrote: > I have table post (id INT and parent VARCHAR) > > +------+-------------+ > | id | parent | > +------+-------------+ > | 1 | 0 | > | 2 | 0 | > | 3 | 1 | > | 4 | 0 | > | 5 | 1 | > | 6 | 0 | > | 7 | 1,5 | > | 8 | 1,5 | > | 9 | 1,5 | > | 10 | 5,7,11 | > | 11 | 1,5,7,10 | > | 12 | 1,5,7,10,11 | > +------+-------------+ > > SELECT id FROM post WHERE where id IN (SELECT parent FROM post WHERE id = > 10); > +------+ > | id | > +------+ > | 5 | > +------+ > > whereas the results I want is > > +------+ > | id | > +------+ > | 5 | > | 7 | > | 11 | > +------+ > > Please tell me, where is wrong > > Thanks & Regards > -- > Muhammad Subair > +62 8176583311 > -- ----------------------------- Johnny Withers 601.209.4985 joh...@pixelated.net