Received: from www.e-cameroun.com (63-123-228-200.douala1.com [63.123.228.200] (may be forged)) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2K8hAN78505 for ; Tue, 20 Mar 2001 03:43:11 -0500 (EST) (envelope-from rachel@derniere-minute.org) Received: from toto (unknown [192.168.1.97]) by www.e-cameroun.com (Postfix) with SMTP id 744D332612 for ; Tue, 20 Mar 2001 09:47:04 +0100 (WAT) Message-ID: <002601c0b11a$8e1e7280$6101a8c0@spidinfo.com> From: "Rachel Coin" To: Subject: Categories and subcategories Date: Tue, 20 Mar 2001 09:48:21 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200103/386 X-Sequence-Number: 2054 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