Re: [SQL] Newbie: Creative use of LIMIT??

2002-07-18 Thread Richard Huxton
On Wednesday 17 Jul 2002 3:20 am, Shmuel A. Kahn wrote: > Assuming I have the following two tables of people and their nicknames, > and that I want to create a list containing UPTO 2 (or any value > greater than 1) nicknames for EACH member of a specific family (Fam > column), how would I do this?

[SQL] Newbie: Creative use of LIMIT??

2002-07-16 Thread Shmuel A. Kahn
Hello all, Being pretty new at SQL, I have a problem I don't know how to solve. Assuming I have the following two tables of people and their nicknames, and that I want to create a list containing UPTO 2 (or any value greater than 1) nicknames for EACH member of a specific family (Fam column),