Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id B08B7476D13
	for <pgsql-sql@postgresql.org>; Fri, 20 Sep 2002 10:47:26 -0400 (EDT)
Received: from hotmail.com (f9.law9.hotmail.com [64.4.9.9])
	by postgresql.org (Postfix) with ESMTP id E2D3A476811
	for <pgsql-sql@postgresql.org>; Fri, 20 Sep 2002 10:47:25 -0400 (EDT)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Fri, 20 Sep 2002 07:46:26 -0700
Received: from 64.7.127.220 by lw9fd.law9.hotmail.msn.com with HTTP;
	Fri, 20 Sep 2002 14:46:26 GMT
X-Originating-IP: [64.7.127.220]
From: =?iso-8859-1?B?UmljYXJkbyBKYXZpZXIgQXJhbmliYXIgTGXzbg==?=
	<ricardo_jal@hotmail.com>
To: pgsql-sql@postgresql.org
Cc: ricardo_jal@linuxmail.org
Subject: query concat
Date: Fri, 20 Sep 2002 14:46:26 +0000
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1; format=flowed
Message-ID: <F9ao8KK8ZtP0kvdIBir000092c1@hotmail.com>
X-OriginalArrivalTime: 20 Sep 2002 14:46:26.0963 (UTC)
	FILETIME=[7F857E30:01C260B4]
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200209/243
X-Sequence-Number: 9520

Hi List,
First, Thanks for your colaboration Richard Huxton "Do a search on aggregate 
functions and "concat" in the mailing list archives,
also see the Postgresql Cookbook on techdocs.postgresql.org, I think there 
might be something there for you."

I have been written this mail because I din't find the solution for my 
problem.

Please, I need your colaboration,I like a table or view with this 
information from 2 tables "ticket" and "orden_respuesta".
If you see the table "orden_respuesta", I have many numorden's for one 
numtti. and in the table "ticket" I have a tti with information about user.

The Table "result"(I like this information)
    numtti |          numorden         |   tt   | usuario |  estado |
----------+---------------------------+--------+---------+---------+
TTI02000006| ORD02000044, ORD02000045..| 100029 | joroza  | CERRADO |
TTI02000007| ORD02000061, ORD02000064  | 100051 | pdorado | REVISION|
TTI02000008| ORD02000042, ORD02000043  | 56729  | joroza  | CERRADO |

(I have this tables as information)
Table "ticket"
            tti     |   tt   | usuario |  estado  |
       -------------+--------+---------+----------+
        TTI02000006 | 100029 | joroza  | CERRADO  |
        TTI02000007 | 100051 | pdorado | REVISION |
        TTI02000008 | 100049 | joroza  | CERRADO  |

Table "orden_respuesta"
          numorden  |   numtti
        ------------+-------------
        ORD02000046 | TTI02000006
        ORD02000045 | TTI02000006
        ORD02000044 | TTI02000006
        ORD02000064 | TTI02000007
        ORD02000061 | TTI02000007
        ORD02000043 | TTI02000008
        ORD02000042 | TTI02000008

Regards,
Ricardo

P.D: Sorry for my grammar I'm from Bolivia, but I understand Enghish

_________________________________________________________________
MSN Fotos: la forma más fácil de compartir e imprimir fotos. 
http://photos.msn.es/support/worldwide.aspx