Re: [GENERAL] Getting several columns from subselect with LIMIT 1

2008-09-20 Thread Merlin Moncure
On Sat, Sep 20, 2008 at 11:36 AM, Pierre Thibaudeau <[EMAIL PROTECTED]> wrote: > I have a PERSONS table. > I also have a PROGENY table, which is a many-to-many association table > with two foreign keys to the PERSONS table to itself. > (In this day and age, not only can an individual have any numbe

Re: [GENERAL] Getting several columns from subselect with LIMIT 1

2008-09-20 Thread Marcus Engene
Pierre Thibaudeau wrote: I have a PERSONS table. I also have a PROGENY table, which is a many-to-many association table with two foreign keys to the PERSONS table to itself. (In this day and age, not only can an individual have any number of children, but also a person can have any number of pare