Received: from ns0.ovh.net (b1.ovh.net [213.186.33.51] (may be forged)) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f27J1nx24049 for ; Wed, 7 Mar 2001 14:01:49 -0500 (EST) (envelope-from rachel@derniere-minute.org) Received: (qmail 4913 invoked by uid 503); 7 Mar 2001 18:59:41 -0000 Received: from unknown (HELO toto) (63.123.228.200) by mail1.ha.ovh.net with SMTP; 7 Mar 2001 18:59:41 -0000 Message-ID: <00b701c0a739$c8170460$6101a8c0@spidinfo.com> From: "Rachel Coin" To: Subject: work on rows Date: Wed, 7 Mar 2001 20:06:48 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00B4_01C0A742.241044E0" 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/157 X-Sequence-Number: 1810 This is a multi-part message in MIME format. ------=_NextPart_000_00B4_01C0A742.241044E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I have a problem with a sql query.I have two tables : the first contains ca= tegories and the second subcategories. What kind of select may I use to get something like Yahoo! categories ( eac= h "main" category gets *at most* three sub-categories.. Thanks Regards, Rachel ------=_NextPart_000_00B4_01C0A742.241044E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello,
 
I have a problem with a sql query.I have t= wo tables=20 : the first contains categories and the second subcategories.
 
What kind of select may I use to get somet= hing like=20 Yahoo! categories ( each "main" category gets *at most* three=20 sub-categories..
 
Thanks
Regards,
 
Rachel
 
 
 
 
------=_NextPart_000_00B4_01C0A742.241044E0--