From: Ricardo Javier Aranibar León <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
Message-ID: <F9ao8KK8ZtP0kvdIBir000092c1@hotmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ricardo_jal@hotmail.com, ricardo_jal@linuxmail.org
Subject: Re: query concat
In-Reply-To: <F9ao8KK8ZtP0kvdIBir000092c1@hotmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox