Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id DDA52476DB8 for ; Fri, 20 Sep 2002 06:45:34 -0400 (EDT) Received: from anchor-post-39.mail.demon.net (anchor-post-39.mail.demon.net [194.217.242.80]) by postgresql.org (Postfix) with ESMTP id D8CFE476D69 for ; Fri, 20 Sep 2002 06:45:30 -0400 (EDT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-39.mail.demon.net with esmtp (Exim 3.36 #2) id 17sLHI-0000d5-0U; Fri, 20 Sep 2002 11:44:53 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 99E6916545; Fri, 20 Sep 2002 11:37:00 +0100 (BST) Received: from client.archonet.com (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with ESMTP id 05D3A15D34; Fri, 20 Sep 2002 11:36:59 +0100 (BST) Content-Type: text/plain; charset="iso-8859-1" From: Richard Huxton Organization: Archonet Ltd To: Ricardo Javier Aranibar =?iso-8859-1?q?Le=F3n?= , pgsql-sql@postgresql.org Subject: Re: Date: Fri, 20 Sep 2002 11:35:59 +0100 User-Agent: KMail/1.4.1 References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200209201135.59993.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/238 X-Sequence-Number: 9515 On Thursday 19 Sep 2002 9:30 pm, Ricardo Javier Aranibar Le=F3n wrote: > Hi list, Hi Ricardo > I need your colaboration,I like a table or view with this information > from 2 tables "ticket" and "orden_respuesta". > > numtti | numorden | tt | usuario | estado | > -----------+---------------------------+--------+---------+---------+ > TTI02000006| ORD02000046, ORD02000045..| 100029 | joroza | CERRADO | > > -------------+--------+---------+----------+ > TTI02000006 | 100029 | joroza | CERRADO | > > -------------+------------- > ORD02000046 | TTI02000006 > ORD02000045 | TTI02000006 Do a search on aggregate functions and "concat" in the mailing list archive= s,=20 also see the Postgresql Cookbook on techdocs.postgresql.org, I think there= =20 might be something there for you. That's assuming you don't care about order of course. - Richard Huxton