Thread: 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

Rachel,

> 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.

I can think of several ways to do this, but they all depend on what
display results you're trying to get.  Perhaps you could post some
simplified tabledefs, and the result you want to see?

-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco