[SQL] Categories and subcategories : more details

> I have two tables : the first for categories and the second for > subcategories.I want to get a result like Yahoo! For each category , > the sql > query must return maximum 3 subcategories. I can't use "limit" in a > subquery > because I use Postgresql 7.0. Examples : table CATEG : ida ca

[SQL] Categories and subcategories

Hi, I have two tables : the first for categories and the second for subcategories.I want to get a result like Yahoo! For each category , the sql query must return maximum 3 subcategories. I can't use "limit" in a subquery because I use Postgresql 7.0. Any help? Regards, Rachel -

[SQL] work on rows

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