Re: [SQL] work on rows

2001-03-07 Thread dev
Author: Rachel Coin <[EMAIL PROTECTED]> I have a problem with a sql query.I have two tables : the first contains categories and the second subcategories. What kind of select may I use to get something like Yahoo! categories ( each "main" category gets *at most* three sub-categories.. Do yo

[SQL] work on rows

2001-03-07 Thread Rachel Coin
Hello,   I have a problem with a sql query.I have two tables : the first contains categories and the second subcategories.   What kind of select may I use to get something like Yahoo! categories ( each "main" category gets *at most* three sub-categories..   Thanks Regards,   Rachel